Re: Do any of you know?
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Oct 2012 17:11:08 +0800
For pretty much all kinds of stats now, there is a "rolling invalidation"
period that is applied to avoid a parse storm...
Look for _optimizer_invalidation_period (or something similar to that).
Cheers
Connor
On Fri, Oct 12, 2012 at 11:05 PM, <Christopher.Taylor2@xxxxxxxxxxxx> wrote:
> Correct. I know that.
>
> I use dbms_pool.purge to flush the plan information. I wasn't clear on
> that I guess.
>
> Chris
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of MacGregor, Ian A.
> Sent: Friday, October 12, 2012 9:59 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Do any of you know?
>
> Taking system stats does not invalidate cursors. Statements will
> continue to use the same plans until they are re-parsed for other reasons,
>
> Ian A. MacGregor
> SLAC National Accelerator Laboratory
> Computing Division
>
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Christopher.Taylor2@xxxxxxxxxxxx [
> Christopher.Taylor2@xxxxxxxxxxxx]
> Sent: Friday, October 12, 2012 7:43 AM
> To: jonathan@xxxxxxxxxxxxxxxxxx; mwf@xxxxxxxx; niall.litchfield@xxxxxxxxx;
> oratune@xxxxxxxxx; breitliw@xxxxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Do any of you know?
>
> When gathering SYSTEM stats, do those stats take a while to affect the
> query plans once they are collected? (a "while" being some "x" amount of
> time - I thought they would be immediate)
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Connor McDonald
===========================
blog: connormcdonald.wordpress.com
web: http://www.oracledba.co.uk
"If you are not living on the edge, you are taking up too much room."
- Jayne Howard
--
//www.freelists.org/webpage/oracle-l
Other related posts:
