oracle跟踪会话级别的10046事件

1.开启10046跟踪事件

alter session set events '10046 trace name context forever, level 12';

2.执行要跟踪的sql语句

select * from scott.emp where SAL>800;

3.停止10046事件跟踪

alter session set events '10046 trace name context off';

4.定位此次生成的trace文件

select distinct(m.sid),p.pid,p.spid,s.serial

p.tracefile from v$mystat m,v$session s,v$process p where m.sid=s.sid and s.paddr=p.addr;

5.用tkprof工具格式化文件输出

tkprof /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_23277.trc  ./my_trace_0410.txt