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 the function of checkpoint(CKPT)?
• What is oracle Architecture?
What is an Oracle Data Block?
What is an Oracle Data Dictionary?
What is Dedicated Server Configuration?
How to implement the multiple control files for an existing database ?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is meant by free extent ?
What is a Control file ?
What is PGA?
What is use of Rollback Segments In Database ?
Name the ORACLE Background Process?