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 |
What is the function of checkpoint(CKPT)?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is Shared Pool?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How does Space allocation table place within a block ?
What is an Integrity Constrains in Oracle?
How many Dispatcher Processes are created?
What is advantage of having disk shadowing/ Mirroring ?
How to define Data Block size in Oracle?
How will you create multiple rollback segments in a database ?
• What is oracle Architecture?
How the log writer writes the data into database