Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by recursive hints ?
- 1 Answers
- 4513 Views
- I also Faced
- E-Mail Answers
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 |
More Oracle Architecture Interview Questions
When Does DBWR write to the database?
What is Server Process?
• What is oracle Architecture?
What is dictionary cache ?
When does LGWR write to the database?
What is PGA?
What is a Parallel Server option in ORACLE?
How can we plan storage for very large tables ?
How many Dispatcher Processes are created?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How will you force database to use particular rollback segment?
What is an Oracle Data Block?
Oracle General 
