RE: SQL stored outlines

Did you read my first suggestion? Here it is again:

        select outline_category from v$sql where sql_id = <your_sql_id>;

Just find the sql_id and/or hash_value of the query you're running through SQL*Plus and then check it in v$sql.

Also, I'd disagree with this statement: "I know I can safely drop the outline"

Just because you get a good plan this time doesn't ensure you're always going to get a good plan - it could (and probably will) change in the future due to new statistics, new bind variables, etc. This is a VERY common problem and the main reason why I still use stored outlines for a handful of queries in 10gR2.

Regards,
Brandon

-----Original Message-----

From: richa03_at_gmail.com [mailto:richa03_at_gmail.com]

if they don't or if we get a better plan, I know I can safely drop the outline,

I want to know for a fact that the SQL I enter into SQL*Plus is the exact statement contained in dba_outlines, that it matched when use_stored_outlines=true and that it didn't use the stored outline when use_stored_outlines=false. Is there any way to do this?

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 24 2007 - 12:45:17 CDT