Re: Displaying and comparing large, ugly explain plans
Date: Thu, 24 Jul 2014 17:52:42 +0400
Message-ID: <OF7524B1CA.21D73E85-ON44257D1F.004C0EB1-44257D1F.004C3C4C_at_psbank.ru>
I have a couple own scripts for such purposes:
- https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql
- 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> _at_plans_active 0ws7ahf1d78qa
2. diff_plans:
SQL> _at_diff_plans 0ws7ahf1d78qa
- Diff plans by sql_id. Version with package XT_PLANS. Usage: _at_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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 24 2014 - 15:52:42 CEST