RE: SQL stored outlines

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Sat, 25 Aug 2007 09:48:25 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAFC4B5D3@MSXVS04.trivadis.com>

> Is there any way to determine if a SQL statement entered via SQL*Plus
> is using a stored outline other than the fact that the plan changes?

You already get plenty of good information. I would just like to add one that I didn't see in the other replies. And, IMHO, it is the easiest ;-)

Since you are working with 10.2 there is only a good way to have a look to an execution plan: to use dbms_xplan. If you do it you will see that in the section containing the notes the utilization of outlines is provided. Here an example (notice the last line):

SQL> SELECT * FROM table(dbms_xplan.display(NULL,NULL,'basic +note'));

Plan hash value: 1601196873

| Id | Operation | Name |

| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| T |

Note

outline "P_OUTLINE_EDITING" used for this statement

HTH
Chris

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

Received on Sat Aug 25 2007 - 02:48:25 CDT