What is meant by recursive hints ?
- 1 Answers
- 4682 Views
- I also Faced
- E-Mail Answers
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 the maximum size of a oracle9i database?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is PGA?
What is the function of Dispatcher (Dnnn)?
Name the ORACLE Background Process?
Why query fails sometimes ?
How the space utilisation takes place within rollback segments?
What is meant by free extent ?
What is the use of Oracle Control File?
What is SGA?
What are disadvanteges of having raw devices ?
What is hit ratio ?
Oracle General 
