Re: Compare two AWR execution plan
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 7 Nov 2016 23:30:24 +0300
Message-ID: <CAOVevU5PdotVEkARHkwvMavcv06jG6k=VUJx5Rwx-JNR+37txQ_at_mail.gmail.com>
Date: Mon, 7 Nov 2016 23:30:24 +0300
Message-ID: <CAOVevU5PdotVEkARHkwvMavcv06jG6k=VUJx5Rwx-JNR+37txQ_at_mail.gmail.com>
> 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
These 2 scripts will produce the same output as you can see on these
screenshots:
http://orasql.org/2014/07/25/standalone-sqlplus-script-for-plans-comparing/
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 07 2016 - 21:30:24 CET