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