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 |
How would you best determine why your MVIEW couldnt FAST REFRESH?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What are cursor?where are they used?
Explain the use of ignore option in imp command.
what are the different types of cursors? explain?
How to convert characters to times in oracle?
Differentiate between function and procedure in oracle.
How to commit the current transaction in oracle?
How to use subqueries with the in operator using oracle?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to run create database statement?