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
how to handle exceptions in post production
Explain the use of rows option in imp command.
material view and view disadvantages?
Explain database link?
How to resolve the ORA-39133 error in Oracle?
What are a cluster and non-cluster index?
How to run create database statement again?
What are triggers in oracle?
Explain overloading. Can functions be overloaded?
What is transaction control statement and how many types of transaction control statement in Oracle?
What would you do with an in-doubt distributed transaction?
What is the difference between sharding and replication?
How do I know if oracle client is installed on windows?
What happens if the update subquery returns multiple rows?
What is merge statement used for?