Re: SQL stored outlines
- From: richa03@xxxxxxxxx
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- Date: Fri, 24 Aug 2007 12:49:01 -0700
Thank you very much Riyaj - I didn't even think of level 12 10046 -
just what I need.
Brandon, that's a pretty condescending post...I'm not a newb and your
response is less than helpful. I fully expect plans to change with
changes in data, skew and parameters. Hope your day (and weekend)
goes better than than your response indicates...
On 8/24/07, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
> 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?
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
