10046可以跟踪其他session
方法一:
1.得到spid
select spid from v$session s ,v$process p where s.paddr=p.addr and s.sid =13 ;
2 开启10046
SQL> oradebug setospid 26112
Oracle pid: 81, Unix process pid: 26112, image: oracle@hostname
SQL> oradebug tracefile_name;
/tracefile/test_ora_26112.trc
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug event 10046 trace name context forever ,level 12;
Statement processed.
3 执行会话,完成关闭10046
SQL> oradebug event 10046 trace name context off;
Statement processed.
SQL> exit
4 查看trace文件
cnsh281003:t0fwa > tkprof t0fwa_ora_26112.trc test1.txt
方法二
SQL> set serverout on;
SQL&g