dbms_stats no invalidate Parameter

From: <zigzagdna_at_yahoo.com>
Date: Sat, 25 Oct 2008 13:06:34 -0700 (PDT)
Message-ID: <659ba9dd-38bf-48ef-9ef3-1b0f0faaf445@j68g2000hsf.googlegroups.com>

dbms_stats.gather_schema_stats (.., no invalidate=>FALSE, )

I am on on HP UNIX. I am trying to understand the pupose of no_invalidate parameter. It is my understanding that default value of this parameter used to be FALSE, but in Oracle 10g it is AUTO_INVAIDATE i.e., Oracle will decide when to make depdent cursors invalid.

What is the drawback of setting it to FALSE, i.e., when new statistics is calculated, Oracel will use it for all cursors (dependent or non dependent) I will like my new staistics to be used ASAP.

Apprecaite your insight.

Thanks a lot. Received on Sat Oct 25 2008 - 15:06:34 CDT

Original text of this message