Re: Semi-OT: Vi Question/Need
- From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
- To: tanel@xxxxxxxxxxxxxx
- Date: Sun, 17 Mar 2013 08:38:02 -0500
Or you could use SQL*Plus to get what you want in the first place. (use substr
and a few where clauses)
SYS@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@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@xxxxxxxxxxxx> 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 {}).
>>
>>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
