Re: Enforcing plan via SQL plan baseline

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 7 Feb 2012 07:14:30 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5ACCF9EC_at_smxc002.trivadis.com>

Hi Amit

> While testing DBMS_SPM I found that if we use alias in query and copy that
> plan to original statement, it will not work.

The hints stored in a SQL plan baseline references the tables via their aliases. Hence, you cannot use hints generated by a statement with aliases for a statement without aliases.

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch

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

Received on Tue Feb 07 2012 - 01:14:30 CST

This message: [ Message body ]
Next message: Laimutis.Nedzinskas_at_seb.lt: "new 11g V$ and AWR views and columns"
Previous message: amit bansal: "Re: Enforcing plan via SQL plan baseline"
Maybe in reply to: Hameed, Amir: "Enforcing plan via SQL plan baseline"
Next in thread: Laimutis.Nedzinskas_at_seb.lt: "new 11g V$ and AWR views and columns"
Reply: Laimutis.Nedzinskas_at_seb.lt: "new 11g V$ and AWR views and columns"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message