Answer Posted / sawant
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 | 1 No |
Post New Answer View All Answers
Explain joins in oracle?
How do I manually uninstall oracle client?
What are transaction isolation levels supported by oracle?
What is the difference between truncate & delete command?
What is an oracle cursor variable?
What do you mean by cdb and pdb in oracle 12c?
How to define a variable to match a table column data type?
How many categories of data types?
How many memory layers are in the oracle shared pool?
Briefly explain what is literal? Give an example where it can be used?
How can we delete duplicate rows in a table?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain what does a control file contain?
What is Library Cache in Oracle?
How to insert a new row into a table in oracle?
