Re: SQL stored outlines

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 25 Aug 2007 11:29:16 +0800
Message-Id: <200708250329.l7P3TDOI016217@smtp12.singnet.com.sg>

Check v$SQL ?

From the definition of V$SQL :
OUTLINE_CATEGORY VARCHAR2(64) If an outline was applied during construction of the cursor, then this column displays the category of that outline. Otherwise the column is left blank.

At 12:50 AM Saturday, richa03_at_gmail.com wrote:
>10.2.0.3 Linux x86-64
>
>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?
>--
>http://www.freelists.org/webpage/oracle-l

Hemant K Chitale
http://hemantoracledba.blogspot.com

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

Received on Fri Aug 24 2007 - 22:29:16 CDT