ass109.awk 分析oradebug产生的trc文件

最新推荐文章于 2021-04-08 06:53:52 发布

lv941002

最新推荐文章于 2021-04-08 06:53:52 发布

阅读量344

点赞数

本文链接：https://blog.csdn.net/lv941002/article/details/82593665

版权


SYS@PROD>oradebug setmypid;
Statement processed.
SYS@PROD> oradebug event 10049 trace name context forever,level 528;
Statement processed.
SYS@PROD>select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
         1 dept           peijiaying
SYS@PROD>oradebug tracefile_name;
/u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_ora_4154.trc
SYS@PROD>
awk -f ass109.awk /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_ora_4154.trc

orgdebug event 10046 trace name context forever,level 12;