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
Is the After report trigger fired if the report execution fails ?
How to insert multiple rows with one insert statement in oracle?
What is the Tune Query
What do you mean by group by clause?
What is the minimum client footprint required to connect c# to an oracle database?
How do I manually uninstall oracle client?
How to create a new table by selecting rows from another table?
How to open a cursor variable?
What are the attributes of cursor?
How to bring a tablespace offline?
Explain what are the characteristics of data files?
What is the use of file param in imp command?
Can a formula column referred to columns in higher group ?
What is the sid in oracle?
How many categories of data types in oracle?
