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 |
What is Database Buffers ?
What is Server Process?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is Shared Pool?
What is a Rollback segment entry ?
What is function of RECO?
What is an Oracle Rollback Segment?
What is Cursor?
When Does DBWR write to the database?
What do Redo Log Buffers contain?
What constitute an ORACLE Instance?
What is an Oracle SYSTEM tablespace and when is it Created?