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 the most common interview questions on ETL Testing for experience?
What do you mean by a database transaction & what all tcl statements are available in oracle?
when do u go for hash partitioning?
which statement is running fastly ie insert or delete?
What is BBED in Oracle?
Explain what are synonyms used for?
Who i will insert 1 lacks record in a Database table
How to insert multiple rows with one insert statement in oracle?
am completed mca2011 how get certification in oracle
What are a collation and state the different types of collation sensitivity?
List out the types of joins.
difference between procedures and function?