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 a proxy class?
How will you differentiate between varchar & varchar2?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is clustered table in Oracle?
What is the difference between hot backup and cold backup in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the differences between char and nchar in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
How many types of cluster table in Oracle?
Define oracle database
What is the difference between sharding and partitioning?
How to loop through a cursor variable?
What is the difference between "as" and "is" in an oracle stored procedure?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to rename an index in oracle?