RE: dbms_stats.auto_invalidate

> 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