What is dictionary cache ?
Answers were Sorted based on User's Feedback
Answer / vivek
it is a part of shared pool which contains most recently
used dictionary data like priviledges, objects,
users,packages....
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ravi dutta.
it is a component of SGA. this is used to check the syntax
and the semantics of the query.
| Is This Answer Correct ? | 1 Yes | 3 No |
How can you find the size of a database?
What is a Control file ?
When does LGWR write to the database?
How does Space allocation table place within a block ?
How many Dispatcher Processes are created?
List the factors that can affect the accuracy of the estimations ?
What is the functionality of SYSTEM table space ?
what is ORACLE MEMORY STRUCTURES
How will you swap objects into a different table space for an existing database?
What are functions of PMON?
What are the functions of SMON?
What are the two types of Server Configurations?