Re: Enforcing plan via SQL plan baseline

From: Christian Antognini <>
Date: Tue, 7 Feb 2012 07:14:30 +0000
Message-ID: <>

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.

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008

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

Original text of this message