RE: Survey: 11g plan management (DBMS_SPM)

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Fri, 17 Jun 2011 06:14:34 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B3063B038A7A61_at_mail02.mba.xifin.com>

Currently, using SPM on a very limited basis.

There's a bug

1. DBMS_XPLAN.DISPLAY_SQL_PLAN_BASELINE CAUSES ORA-979 IF CURSOR_SHARING=FORCE/SIMI

And now working on another issues where SPM-999 error and plan cannot evolve.

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Laimutis.Nedzinskas_at_seb.lt [Laimutis.Nedzinskas_at_seb.lt] Sent: Thursday, June 16, 2011 10:49 PM
To: oracle-l_at_freelists.org
Subject: Survey: 11g plan management (DBMS_SPM)

Hi

      Did anyone made use of 11g plan management to enforce plan
      stability ? What's the impression ? Or may be 11g cost based
      optimizer evolved enough bringing newly arrived plan stability
      largely irrelevant :)))) ?

      Guess what, oracle now has:


            - outlines

            - sql profiles

            - spm (plan management)

      Make your choice :))))  Anyway, spm looks quite thought of facility,
      seriously.

      Thank you in advance, Laimis N,

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 17 2011 - 08:14:34 CDT