What is meant by recursive hints

  • Interview Candidate
  • 1
  • 4264

Editorial / Best Answer

sushilsb  

  • Member Since May-2006 | Jun 2nd, 2006

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.

Showing Answers 1 - 1 of 1 Answers

sushilsb

  • Jun 2nd, 2006
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions