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 are the differences between lov and list item?
How to download oracle database 10g xe?
How to use existing values in update statements using oracle?
What are the logical operations?
What is parameterized cursor in oracle?
Is there any function in oracle similar like group_concat of mysql?
Does oracle partitioning improve performance?
How to find out what oracle odbc drivers are installed?
How would you go about verifying the network name that the local_listener is currently using?
What happens if variable names collide with table/column names?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to export your own schema?
What is the simplest tool to run commands on oracle servers?
How to drop an index?
Hi Can any one tell me what are the API's used in requisition import.