Mr. Lewis has a lot about Stored Outlines on his site. Most of it is in the
SQL Profiles posts.
On Fri, Jan 8, 2021 at 10:04 AM l.flatz@xxxxxxxxxx <l.flatz@xxxxxxxxxx>
Stored outlines are part of plan stability, an adtemp to keep execution
always a good place to start is the documentation or Tim's website:
Von : eramitsaroha@xxxxxxxxx
Datum : 08/01/2021 - 16:56 (MN)
An : oracle-l@xxxxxxxxxxxxx
Betreff : Oracle Stored Outlines Interpretation
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.