Re: Oracle Stored Outlines Interpretation

Mr. Lewis has a lot about Stored Outlines on his site. Most of it is in the SQL Profiles posts.
https://www.google.com/search?q=%22stored+outlines%22+site:jonathanlewis.wordpress.com

Seth

On Fri, Jan 8, 2021 at 10:04 AM l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> wrote:

> Hi,
>
> Stored outlines are part of plan stability, an adtemp to keep execution
> plans frozen.
> always a good place to start is the documentation or Tim's website:
> https://oracle-base.com/articles/misc/outlines
>
> Regards
>
> Lothar
>
> ----Ursprüngliche Nachricht----
> Von : eramitsaroha_at_gmail.com
> Datum : 08/01/2021 - 16:56 (MN)
> An : oracle-l_at_freelists.org
> Betreff : Oracle Stored Outlines Interpretation
>
> Hi All,
>
> A recent thread on OTN caught my thought where Mr. Jonathan Lewis is
> describing query performance issues by referring to stored outlines in the
> execution plan. I tried going through the web but couldn’t spot any
> satisfying information to figure out these.
>
> Could you please help me know what these do?, and request you to give some
> clues, how I can read and value the pieces of information they have in
> query performance tuning and direct me to some blog posts, books, or any
> article to know these in a better way.
>
>
> Thank you for all your help and support in this regard.
>
>
> Best Regards,
> A.S.
>
>
>

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