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 |
Explain a segment?
What to do if the binary spfile is wrong for the default instance?
How to select the name of employee who is getting maximum sal with out using subquery
What happens to the indexes if a table is recovered?
What is control file used for?
where we have to use ON clause and where we have to use USING clause in JOINS
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
How to test null values?
What is a subquery?
difference between procedures and function?
What are the ways tablespaces can be managed and how do they differ?
Does oracle charge for java?