RE: dbms_stats.auto

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Mon, 9 Oct 2006 19:51:55 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF7246B9@WIN02.hotsos.com>

The default behavior in 9 and earlier is that when new stats are collected all dependent cursors are invalidated, meaning a hard parse will happen the next time the cursor is referenced.

Starting in 10 the default is to NOT invalidate cursors when new stats are collected. Which means that after collecting new stats on an object dependent cursor will not be hard parsed the next time they are referenced.

Ric Van Dyke
Hotsos Enterprises

Hotsos Symposium March 4-8, 2007. Be there.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stalin Sent: Monday, October 09, 2006 6:39 PM
To: Oracle Discussion List
Subject: dbms_stats.auto_invalidate

Hi,

I couldn't find any references as to when oracle would decide to validate or not_validate dependent cursors upon gather stats. Any plausible explanation is appreicated.

Thanks,
Stalin

10g (10.1.0.4)
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 09 2006 - 19:51:55 CDT

RE: dbms_stats.auto_invalidate