Re: Monitoring CBO degrading Switches in xplans?
Date: Thu, 18 Jun 2009 17:04:36 -0500
Did you try turning off bind variable peeking or histograms?
On Thu, Jun 18, 2009 at 4:51 PM, Fmhabash <fmhabash_at_gmail.com> wrote:
> This is an issue that has made sleepless over and over again. Critical
> application sql changes its xplans causing elapse time to go unacceptably
> We eventually wanted to monitor this kind of event proactively. To this
> effect, we query top n sql from awr order by elapsed time. We then compare
> most recent ET value to the previous n samples. We then calculate cost of
> current plan and compare it to existing awr ones cost.
> With all this info, we alert if ET and plan cost exceed thresholds.
> How do you cope with this issue and what have you done to monitor it (logic
> Thank You.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 18 2009 - 17:04:36 CDT