Re: dbms_stats no invalidate Parameter
Date: Mon, 27 Oct 2008 10:27:10 -0700 (PDT)
Message-ID: <370b8f10-2b9e-4dce-a554-fcd61bb0f4f2@h60g2000hsg.googlegroups.com>
On Oct 25, 3:06 pm, zigzag..._at_yahoo.com wrote:
> dbms_stats.gather_schema_stats (.., no invalidate=>FALSE, …)
>
> I am on 10.2.0.4 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.
Posting the exact same message twice does not ingratiate you with those who regularly respond nor does it improve the speed with which responses appear.
Stop doing so.
David Fitzjarrell Received on Mon Oct 27 2008 - 12:27:10 CDT