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 data pump export and import modes?
What a SELECT FOR UPDATE cursor represent.?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
What is java oracle used for?
How to create a temporary table in oracle?
Explain the function of optimizer in oracle?
What types of joins are used in writing subqueries?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What are a query and state the different types of queries and their uses?
Why does oracle 9i treat an empty string as null?