Re: Displaying and comparing large, ugly explain plans

From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
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:
  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> _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

Original text of this message