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 many Dispatcher Processes are created?
How will you force database to use particular rollback segment?
What is Server Process?
What is SGA?
Why query fails sometimes ?
Can a Tablespace hold objects from different Schemes in Oracle?
What is the maximum number of Lock Processes used?
What is the function of Dispatcher (Dnnn)?
what is the role of archiever
What is the maximum size of a oracle9i database?
How to define Data Block size in Oracle?
How can you find the size of a database?