Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_stats.auto_invalidate
> in a lot of plans. IIRC, auto_invalidate will invalidate
> plans gradually over time, so it is not a decision of whether
> to invalidate a plan or not but a decision which ones to
> invalidate sooner and which ones later.
> But as I said, I could be totally wrong in that.
Yep, this is dependent on _optimizer_invalidation_period parameter, which is
set in seconds.
It defaults to 18000, meaning that all "old" cursors should be invalidated
during 5 hour period since stats gathering.
This should avoid the "hard parse storm" when lots of cursors are dependent on the analyzed objects...
Tanel.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 08:08:00 CDT
![]() |
![]() |