Re: Semi-OT: Vi Question/Need

From: Kerry Osborne <kerry.osborne_at_enkitec.com>
Date: Sun, 17 Mar 2013 08:38:02 -0500
Message-Id: <299FAFC8-3253-4C4C-84C0-1899704A0283_at_enkitec.com>

Or you could use SQL*Plus to get what you want in the first place. (use substr and a few where clauses)

SYS_at_dbm1> l
  1 select substr(PLAN_TABLE_OUTPUT,1,73) PLAN_TABLE_OUTPUT from table(dbms_xplan.display_cursor('&sql_id','&child_no','typical'))

  2  where PLAN_TABLE_OUTPUT like '|%' or PLAN_TABLE_OUTPUT like '-------------------------------------------------------%'

  3* or PLAN_TABLE_OUTPUT like 'SQL_ID%' or PLAN_TABLE_OUTPUT like 'Plan hash value%' SYS_at_dbm1> /
Enter value for sql_id: 1n60q90jkatjj
Enter value for child_no:

PLAN_TABLE_OUTPUT

---

SQL_ID 1n60q90jkatjj, child number 0
Plan hash value: 2886813138

---

| Id  | Operation                   | Name                      | Rows  |
-------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                           |       |
|   1 |  SORT ORDER BY              |                           |     1 |
|   2 |   NESTED LOOPS              |                           |     1 |
|   3 |    NESTED LOOPS             |                           |     1 |
|   4 |     NESTED LOOPS            |                           |     1 |
|   5 |      FIXED TABLE FULL       | X$KSLWT                   |    56 |
|*  6 |      FIXED TABLE FIXED INDEX| X$KSUSE (ind:1)           |     1 |
|*  7 |     FIXED TABLE FIXED INDEX | X$KSLED (ind:2)           |     1 |
|*  8 |    FIXED TABLE FIXED INDEX  | X$KGLCURSOR_CHILD (ind:2) |     1 |
-------------------------------------------------------------------------

15 rows selected.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com
twitter: https://twitter.com/KerryOracleGuy

On Mar 17, 2013, at 6:23 AM, Tanel Poder wrote:

> Use vim and hit *CTRL+V*. Enjoy :-)
>
>
> --
> *Tanel Poder*
> Enkitec (The Exadata Experts)
> Training <http://blog.tanelpoder.com/seminar/> |
> Troubleshooting<http://blog.tanelpoder.com/>
> | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>
> | Voicee App <http://voic.ee/>
>
>
>
> On Sun, Mar 17, 2013 at 12:35 PM, Nuno Souto <dbvision_at_iinet.net.au> wrote:
>

>> cut would be my first choice too.
>> 
>> cut  -c1-40 {fname}     > {newfnam}
>> will cut the first 40 columns of all lines of fname and drop the result
>> in newfname (omit the {}).
>> 
>> 

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

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

Received on Sun Mar 17 2013 - 14:38:02 CET