RE: Survey: 11g plan management (DBMS_SPM)

From: <>
Date: Mon, 20 Jun 2011 14:10:07 +0300
Message-ID: <>

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:         "" <>, "" <>        
  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" <>                                                                   
  To:         <>                                                                                            
  Date:       2011.06.19 13:33                                                                                                    
  Subject:    RE: Survey: 11g plan management (DBMS_SPM)                                                                          


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.


-- Received on Mon Jun 20 2011 - 06:10:07 CDT

Original text of this message