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 |
How can you find the size of a database?
What are the two types of Server Configurations?
How the log writer writes the data into database
What is a Rollback segment entry ?
What is User Process?
What Does DBWR do?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the function of checkpoint(CKPT)?
How the space utilisation takes place within rollback segments?
What is an Oracle Data Segment?
How will you monitor the space allocation ?
Diference between Oracle 9i and 10G.