Monitoring CBO degrading Switches in xplans?
- From: Fmhabash <fmhabash@xxxxxxxxx>
- To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Jun 2009 17:51:35 -0400
This is an issue that has made sleepless over and over again. Critical
application sql changes its xplans causing elapse time to go unacceptably
worst.
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
wise).
---------------
Thank You.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
