Oracle Trace、Oradebug相关

trace跟踪：

----------sql_trace

alter session set sql_trace=true;
alter session set tracefile_identifier='test';
alter session SET EVENTS '10046 trace name context forever, level 12';
select * from tpsoft.c_name a,tpsoft.c_test b where a.testid=b.testid
alter session set events '10046 trace name context off'

找到trace文件  然后结合tkprof工具进行转换

tkprof E:\app\administrator\diag\rdbms\tphy\tphy\trace\tphy_ora_17680_test.trc E:\app\administrator\diag\rdbms\tphy\tphy\trace\trc_1017.trc

----------oradebug

 

SQL> oradebug setmypid

 

SQL> oradebug event 10046 trace name context forever,level 12;

SQL> select * from tpsoft.c_name a,tpsoft.c_test b where a.testid=b.testid;

 

SQL> oradebug event 10046 trace name context off;

SQL> oradebug tracefile_name

 

具体用法及trc文件解读：https://blog.csdn.net/dataminer_2007/article/details/42040853