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?
What are functions of PMON?
What is an Oracle SYSTEM tablespace and when is it Created?
What is a Multi-threaded Server Configuration?
When Does DBWR write to the database?
When will be a segment released?
What is User Process?
what is the role of archiever
What is advantage of having disk shadowing/ Mirroring ?
How can we plan storage for very large tables ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?