Re: Compare two AWR execution plan

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: karlarao@xxxxxxxxx
  • Date: Mon, 7 Nov 2016 23:30:24 +0300

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2016