RE: Semi-OT: Vi Question/Need
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <pbrunoster@xxxxxxxxx>
- Date: Fri, 15 Mar 2013 09:28:13 -0500
Perfect! (Good catch). Change the DBMS_XPLAN format to BASIC instead of
ADVANCED IOSTATS
Thanks!
Chris
From: pier paolo Bruno [mailto:pbrunoster@xxxxxxxxx]
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@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>>
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@xxxxxxxxx<mailto:pbrunoster@xxxxxxxxx>]
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@xxxxxxxxxxxx<mailto:Christopher.Taylor2@xxxxxxxxxxxx>>
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@xxxxxxxxx<mailto:rjamya@xxxxxxxxx>]
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
