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 |
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
how to handle exceptions in post production
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to create a new view in oracle?
without using count(*) and rownum how can we count total record in a table
Name the various constraints used in oracle?
How many types of table in Oracle?
What is a Database instance ? Explain?
what is difference between table and view? where to use views? thanks in advance!
Can a formula column referred to columns in higher group ?
How to convert csv to table in oracle?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?