RE: dbms_stats.auto_invalidate

From: Tanel Poder <tanel.poder.003@xxxxxxx>
To: breitliw@xxxxxxxxxxxxx, stalinsk@xxxxxxxxx
Date: Tue, 10 Oct 2006 22:29:08 +0800

> 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...

Note that I reran the test script which used to work in 10.2.0.1, but on
10.2.0.2 it doesn't seem to reproduce the same way as it did.

Don't have time to investigate now - something might have changed with this
patchset or maybe my test case was just incomplete..

Tanel.
--
http://www.freelists.org/webpage/oracle-l

References:

RE: dbms_stats.auto_invalidate
From: Tanel Poder

RE: dbms_stats.auto_invalidate

Other related posts: