RE: Semi-OT: Vi Question/Need

From: <Christopher.Taylor2_at_parallon.net>
Date: Fri, 15 Mar 2013 09:28:13 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88583164F97_at_NADCWPMSGCMS10.hca.corpad.net>

Perfect! (Good catch). Change the DBMS_XPLAN format to BASIC instead of ADVANCED IOSTATS Thanks!

Chris

From: pier paolo Bruno [mailto:pbrunoster_at_gmail.com] Sent: Friday, March 15, 2013 9:24 AM
To: Taylor Christopher - Nashville
Subject: Re: Semi-OT: Vi Question/Need

if the plan is different use the basic format of dbms_xplan, u will not see all the lines but u will get quite easily where they differ

2013/3/15 <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> Well it's 2 different plans - so the Est Time, the operations are different so several lines will be different and actually just want the lines where the table/index operations are different - but if the times at the end of the rows are different, those same lines will come back and I don't want that.

Chris

From: pier paolo Bruno [mailto:pbrunoster_at_gmail.com<mailto:pbrunoster_at_gmail.com>] Sent: Friday, March 15, 2013 9:09 AM

To: Taylor Christopher - Nashville
Subject: Re: Semi-OT: Vi Question/Need

set lines 2000
set trims on
set trim on
set termout off
set feedb off
set echo off
set pages 0 .... spool on 2 different files... and diff unix command

2013/3/15 <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> Oh - I hadn't thought about doing it from the command line. Not a bad idea...not bad at all. I wish I was on 11.2 - still on 10.2 for now.

Chris

From: rjamya [mailto:rjamya_at_gmail.com<mailto:rjamya_at_gmail.com>] Sent: Friday, March 15, 2013 8:51 AM
To: Taylor Christopher - Nashville
Cc: ORACLE-L
Subject: Re: Semi-OT: Vi Question/Need

you mean something like this (assuming your plans is stored in test.txt), probably easier than vi

->cat test.txt | cut -c 1-73

---

| Id  | Operation                        | Name                         |
-------------------------------------------------------------------------
|   0 | SELECT STATEMENT                 |                              |
|   1 |  HASH UNIQUE                     |                              |

?
Also see dbms_xplan.diff_plan_awr or dbms_xplan.diff_plan_cursor if you wish in 11.2

Raj

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 15 2013 - 15:28:13 CET