What is meant by recursive hints ?
Answer / orawhiz
Number of times processes repeatedly query the dictionary
table is called recursive hints. It is due to the data
dictionary cache is too small. By increasing the
SHARED_POOL_SIZE parameter we can optimize the size of Data
Dictionary Cache.
Is This Answer Correct ? | 0 Yes | 0 No |
How to define Data Block size in Oracle?
When will be a segment released?
When does LGWR write to the database?
Why query fails sometimes ?
What are the uses of Oracle Rollback Segment?
What constitute an ORACLE Instance?
List the factors that can affect the accuracy of the estimations ?
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 are functions of PMON?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How will you force database to use particular rollback segment?
What is Server Process?