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
What is dual table oracle?
 How to use an oracle sequence generator in a mapping?
IS it possible to built the oracle database without setting the kernal parameters?
Can we create database in oracle using command line ?
What is a directory object?
How do I uninstall oracle 11g?
How to find out what oracle odbc drivers are installed?
Is truncate autocommit in oracle?
What do you mean by a deadlock?
How do you tell what your machine name is and what is its IP address?
How to drop an index?
What is recovery manager in Oracle?
What do you mean by group by clause?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is tns service name?