Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Krishnaprasad.

Asked: February 06, 2018 - 7:54 am UTC

Last updated: February 07, 2018 - 5:55 am UTC

Version: 12.c

Viewed 1000+ times

You Asked

hi ,

in my environment i found some of query plans often gets changed, i used 10053 to figure out for plan change ,

but which part to check and how to conclude what is causing plan change that i am not able to figure out can you please help here with some document and example.

and Connor said...

The way I normally use to detect plan changes is via AWR, because we capture plan information with each snapshot.

Kerry Osborne has some nice scripts to assist here

http://kerryosborne.oracle-guy.com/2008/10/unstable-plans/

A 10053 trace will not tell you *why* a plan changed - it will simple give you information about the latest plan.

Normally I would I use dbms_xplan.display to show the two different plans, and work from there.



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library