Re: Semi-OT: Vi Question/Need
From: rjamya <rjamya_at_gmail.com>
Date: Fri, 15 Mar 2013 09:51:05 -0400
Message-ID: <CAGurbTNH6_Nk0f5XySrPsB_kXGLzYNVDDGxumpY0eckWFw28Ow_at_mail.gmail.com>
you mean something like this (assuming your plans is stored in test.txt), probably easier than vi
->cat test.txt | cut -c 1-73
Date: Fri, 15 Mar 2013 09:51:05 -0400
Message-ID: <CAGurbTNH6_Nk0f5XySrPsB_kXGLzYNVDDGxumpY0eckWFw28Ow_at_mail.gmail.com>
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-lReceived on Fri Mar 15 2013 - 14:51:05 CET