RE: SQL stored outlines

Check V$SQL.OUTLINE_CATEGORY.

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx
www.proquest.com
www.csa.com

ProQuest...Start here. 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of richa03@xxxxxxxxx
Sent: Friday, August 24, 2007 12:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQL stored outlines

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


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


Other related posts: