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 numeric comparison operations?
List the types of joins used in writing subqueries?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
what is the syntax of SELECT command?
How many memory layers are in the shared pool?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What privilege is needed for a user to connect to oracle server?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
How to drop an index in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain the use of Merge statement in oracle 11g
What are the four Oracle system processes that must always be up and running for the database to be useable?