跟踪sql方式（10046,10053）

10046
alter session set events '10046 trace name context forever, level 12';
alter session set tracefile_identifier='TRUN';
truncate table SCOTT.TRUN;
alter session set events '10046 trace name context off';
select distinct(m.sid),p.pid,p.tracefile from v$mystat m,v$session s,v$process p where m.sid=s.sid and s.paddr=p.addr;

tkprof TRUN.trc out.txt

 

10053

SQL>alter session set tracefile_identifier='10053';

SQL> alter session set events '10053 trace name context forever ,level 1';

SQL> <execute sql statements>

SQL> alter session set events '10053 trace name context off';