RE: SQL stored outlines

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 24 Aug 2007 14:02:56 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270D2CBAF1@AABO-EXCHANGE02.bos.il.pqe>

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_at_il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of richa03_at_gmail.com Sent: Friday, August 24, 2007 12:50 PM
To: oracle-l_at_freelists.org
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 Received on Fri Aug 24 2007 - 13:02:56 CDT