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.
What are Schema Objects in Oracle?
What are the type of Synonyms in Oracle?
What are the advantages of Views in Oracle?
What is a Public Synonyms in Oracle?
What is a Private Synonyms in Oracle?
What are the Characteristics of Data Files in Oracle?
What is high watermark in oracle?
How does the SMON process performs recovery after instance failure?
Explain what is the back ground process in oracle architecture?
How to determine the physical architecture of oracle?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
