RE: Survey: 11g plan management (DBMS_SPM)
Date: Mon, 20 Jun 2011 14:10:07 +0300
Message-ID: <OF25B3A9A6.A1635E7F-ONC22578B5.003CF894-C22578B5.003D59F8_at_seb.lt>
Thank you all.
From what I got SPM is used on a limited basis, to fix a problematic sql. That's all right.
But did anyone try to use SPM on a global scale? To freeze a stable production application ? Sounds scarry to me but how to know w/o trying ? I can guess some issue like slower sql parsing, latching/"mutexing", etc with a large number of SQL baselines. Would be interesting to know load on CPU either.
Brgds, Laimis
From: Michael Dinh <mdinh_at_XIFIN.Com>
To: "Laimutis.Nedzinskas_at_seb.lt" <Laimutis.Nedzinskas_at_seb.lt>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Date: 2011.06.17 16:18
Subject: RE: Survey: 11g plan management (DBMS_SPM)
Currently, using SPM on a very limited basis.
Please consider the environment before printing this e-mail
From: "Austin Hackett" <Austin.Hackett_at_sportingbet.com>
To: <oracle-l_at_freelists.org>
Date: 2011.06.19 13:33
Subject: RE: Survey: 11g plan management (DBMS_SPM)
Laimis
I’ve been using some SQL Plan Baselines in a production system for a few months now. For me there are 2 really useful features. First, the ability to get the plan you want with hints and then generate a baseline for the problem statement using that plan. Secondly, being able to generate a baseline from a plan contained in the AWR.
Austin
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 20 2011 - 06:10:07 CDT