10046トレースの取り方から整形まで（乱用厳禁）

忘れないようにメモ

====

開始

FFM(SYS)> select sid,serial#,username from v$session where username is not null;

SID SERIAL# USERNAME

---------- ---------- ------------------------------------------------------------------------------------------

300 3277 SYS

305 2652 DBADMIN

306 2854 SYS

308 53 DBSNMP

310 39 DBSNMP

311 3 DBSNMP

8 rows selected.

FFM(SYS)> EXEC DBMS_SYSTEM.SET_EV(305,2652,10046,12,'');

PL/SQL procedure successfully completed.

FFM(SYS)>

停止

FFM(SYS)> EXEC DBMS_SYSTEM.SET_EV(305,2652,10046,0,'');

PL/SQL procedure successfully completed.

FFM(SYS)>

TKPROF

[udump oracle()] pwd

/u01/oracle/app/admin/FFM/udump

[udump oracle()] ls -l

\u5408\u8a08 8

-rw-r----- 1 oracle oinstall 7765 2\u6708 12 16:23 ffm_ora_18348.trc

[udump oracle()] tkprof ffm_ora_18348.trc ffm_ora_18348.txt

TKPROF: Release 10.2.0.4.0 - Production on \u91d1 2\u6708 12 16:25:21 2010

[udump oracle()]