What is meant by recursive hints ?
- 1 Answers
- 3942 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 use of Rollback Segments In Database ?
What is an Oracle SYSTEM tablespace and when is it Created?
What is the function of Redo Log in Oracle?
Name the ORACLE Background Process?
What is meant by free extent ?
What is hit ratio ?
What is meant by recursive hints ?
How will you monitor the space allocation ?
How can we plan storage for very large tables ?
What are the functions of SMON?
Can a View based on another View in Oracle?
What is the functionality of SYSTEM table space ?
Oracle General 
