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 dictionary cache ?
What is hit ratio ?
Which parameter in Storage clause will reduce no. of rows per block?
What is Cursor?
How will you estimate the space required by a non-clustered tables?
How the log writer writes the data into database
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is the use of Oracle Control File?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the maximum number of Lock Processes used?
What is the function of Redo Log in Oracle?
What is meant by recursive hints ?