RE: Do any of you know?
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <ian@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Oct 2012 10:05:40 -0500
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
Other related posts:
