Re: SQL stored outlines

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