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 function of RECO?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is an Oracle Rollback Segment?
What is a Rollback segment entry ?
What are the uses of Oracle Rollback Segment?
Can a View based on another View in Oracle?
What does LGWR do?
What is meant by recursive hints ?
What is use of Rollback Segments In Database ?
What is Cursor?
What is a Multi-threaded Server Configuration?
How will you swap objects into a different table space for an existing database?