Re: SQL stored outlines
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: richa03@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 25 Aug 2007 11:29:16 +0800
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@xxxxxxxxx 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?
--
//www.freelists.org/webpage/oracle-l
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
