The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is Database buffers, Dictionary cache, Redo Log Buffer and Shared SQL pool (ver 7.0 only) area.
How does archive log file helps to make backup consistent?
What is schema in Oracle Architecture?
Where does the process dumps information about the error?
What is the use of Redo Log Information in Oracle?
Explain Virtual tables?
What is Oracle Identity Analytics?
What is the diff b/w BTREE INDEX and BITMAP INDEX?
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?
What is Private Database Link in Oracle?
What is Data Block in Oracle Architecture?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
