Oracle 10035追踪解析失败的SQL
SQL> ALTER SYSTEM SET EVENTS '10035 trace name context forever, level 1';
SQL> select * from xxxooo;
SQL> ALTER SYSTEM SET EVENTS '10035 trace name context off';
告警日志:
OS Pid: 1548 executed alter system set events '10035 trace name context forever, level 1'
34883 PARSE ERROR: ospid=1548, error=942 for statement:
34884 select * from xxxooo^@
34885 Additional information: hd=0x17e65cbf0 phd=0x17e65ce50 flg=0x28 cisid=88 sid=88 ciuid=88 uid=88
34886 PARSE ERROR: ospid=1548, error=942 for statement: