What is meant by recursive hints ?
- 1 Answers
- 5898 Views
- I also Faced
- E-Mail Answers
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 |
How can I introduce multiple conditions in like operator?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is analyze command used for?
List the various oracle database objects?
How to start an oracle instance?
Explain how are indexes update?
How do we display rows from the table without duplicates?
How to call a stored function in oracle?
Explain integrity constraints?
How to write a query with an inner join in oracle?
How will you write a query to get a 5th rank student from a table student_report?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Oracle General 
