What is meant by recursive hints ?
Answer / 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 |
what are corelated subqueries
How to define a cusotmer as a supplier in ORACLE R12
What is archive log in Oracle?
What language does oracle use?
how to retrieve 1st and last row of table without using group functions??
What are the different types of failures that occur in Oracle database?
What is transport network substrate (tns) in oracle?
Why we choose emp number as primarykey?
How can I get column names from a table in oracle?
How do you handle duplicate records in a database?
Why cursor variables are easier to use than cursors?
Why do we need integrity constraints in a database?