Re: Compare two AWR execution plan

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_at_freelists.org> 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
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

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