Re: Displaying and comparing large, ugly explain plans
- From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- To: kadmon@xxxxxxxxx
- Date: Thu, 24 Jul 2014 17:52:42 +0400
I have a couple own scripts for such purposes:
1. https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql
2. https://github.com/xtender/xt_scripts/blob/master/plans_active.sql
You can also try another approach: it's quite simple to compare plans
without first column "ID", so you can simply compare "select .. from
v$sql_plan/v$sql_plan_statistics_all/v$sql_plan_monitor" output with any
comparing tool.
My scripts output screenshots:
diff_plans.sql: http://orasql.org/?attachment_id=516
plans_active.sql: http://orasql.org/?attachment_id=518
Usage:
1. plans_active:
SQL> @plans_active 0ws7ahf1d78qa
2. diff_plans:
SQL> @diff_plans 0ws7ahf1d78qa
*** Diff plans by sql_id. Version with package XT_PLANS.
Usage: @plans/diff_plans2 sqlid [+awr] [-v$sql]
P_AWR P_VSQL
--------------- ---------------
false true
PS. Second attempt... first was with attachments
--
Best regards,
Sayan Malakshinov
http://orasql.org
Other related posts:
