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 |
Can a Tablespace hold objects from different Schemes in Oracle?
What is Server Process?
How many Dispatcher Processes are created?
What is an oracle database schema?
What is meant by recursive hints ?
How will you swap objects into a different table space for an existing database?
What is SGA?
What is the maximum number of Lock Processes used?
What is a Multi-threaded Server Configuration?
How will you monitor the space allocation ?
What is meant by free extent ?
Teradata: How can we know the indexed column in a table?