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 |
Explain database link?
What is the max number of columns in an oracle table?
what is the difference between table and veiw?
What is difference between cartesian join and cross join?
How to write a query with a full outer join in oracle?
Explain an exception?
can we insert any row to dual table if i got the permission from DBA
How to use "for" statements in oracle?
Can multiple cursors being opened at the same time?
Why do we use coalesce function in oracle?
what are the different types of cursors? explain?
Can we insert data in view oracle?