RE: Survey: 11g plan management (DBMS_SPM)

From: <Laimutis.Nedzinskas_at_seb.lt>
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

Original text of this message