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 an Oracle Data Block?
What is Shared SQL Area?
How will you create multiple rollback segments in a database ?
What is function of RECO?
How the space utilisation takes place within rollback segments?
what is ORACLE MEMORY STRUCTURES
What are the uses of Oracle Rollback Segment?
Which parameter in Storage clause will reduce no. of rows per block?
How to implement the multiple control files for an existing database ?
What is SGA?
What constitute an ORACLE Instance?
When will be a segment released?