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?
Name the ORACLE Background Process?
what is the role of archiever
When Does DBWR write to the database?
Can a Tablespace hold objects from different Schemes in Oracle?
What is Cursor?
What are the functions of SMON?
What is advantage of having disk shadowing/ Mirroring ?
What is the function of Dispatcher (Dnnn)?
1.Explain the three levels with the help og a diagram.
How to find the current session sid
What is dictionary cache ?