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 |
What is an oracle database schema?
What are the components of SGA?
1.Explain the three levels with the help og a diagram.
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is the function of ARCH?
What is Server Process?
what is the role of archiever
What are the uses of Oracle Rollback Segment?
What are the functions of SMON?
How to implement the multiple control files for an existing database ?
How does Space allocation table place within a block ?
What is the function of Redo Log in Oracle?