ORACLE EVENT事件跟踪

SQL> exec dbms_workload_repository.create_snapshot();

PL/SQL procedure successfully completed.

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

Session altered.

SQL>

SQL> alter system set events '10035 trace name context forever,level 1';

System altered.

SQL>

查看sql来源：

# 这种一般是plsql等客户端的工具写的sql

SQL> oradebug setospid 26630;

Oracle pid: 67,Unix process pid: 26630,image: oracle@pldb1

SQL> oradebug setospid 52811;

ORA-00072: process "52811" is not active

SQL>

# 一般是应用程序过来的sql语句

SQL> oradebug setospid 57135;

ORA-00072: process "57135" is not active

SQL>

看到alert log后，记得关闭：

ALTER SYSTEM SET EVENTS '10035 trace name context off';

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!