Hi Sanjay,
I have 2 scripts for that, but you need to modify them a bit, since I use
preconfigured SQL*Plus(special variables and scripts):
https://github.com/xtender/xt_scripts/blob/master/awr/diff_plans.sql
https://github.com/xtender/xt_scripts/blob/master/awr/diff_plans_active.sql
On Mon, Nov 7, 2016 at 10:59 PM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Hi
Can someone help in guiding the way to compare very big execution plan
available in AWR. I had same statement behaving differently in one of 10g
Dagtabase and after checking the SQL ID and different plan Hash value found
big difference in timing. Now need to compare 5 page Execution plan and so
if someone has done it and can share any process
I had compared the same using sql developer but that is done by running
the SQL with some change in syntax and comparing Autotrace option. Here SQL
is same but plan was different which can be due to Statistics or so
TIA
Sanjay