Write parse failures to alert log file (ORA-10035)

Если нужно временно найти какой-то запрос который выбрасывает ошибку парсинга в приложении, можно воспользоваться следующим event'ом что бы увидеть текст:

oerr ora 10035 10035, 00000, "Write parse failures to alert log file"

Пробуем:

SQL> alter system set events '10035 trace name context forever, level 1'; System altered. SQL> select 1 form dual; select 1 form dual               * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select owner,object_name,count(1) from dba_objects where owner='SYS' group by owner order by 3 desc; select owner,object_name,count(1) from dba_objects where owner='SYS' group by owner order by 3 desc              * ERROR at line 1: ORA-00979: not a GROUP BY expression SQL>  alter system set events '10035 trace name context forever, off';

Проверяем наш alert.log:

OS Pid: 9040 executed alter system set events '10035 trace name context forever, level 1' Tue Sep 22 19:57:01 2015 PARSE ERROR: ospid=9040, error=923 for statement: Tue Sep 22 19:57:01 2015 select 1 form dual Additional information: hd=0x150fc6bc8 phd=0x15227b9e0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0 PARSE ERROR: ospid=9040, error=979 for statement: Tue Sep 22 19:57:05 2015 select owner,object_name,count(1) from dba_objects where owner='SYS' group by owner order by 3 desc Additional information: hd=0x15083b580 phd=0x1508160f0 flg=0x20 cisid=0 sid=0 ciuid=0 uid=0 Tue Sep 22 19:58:37 2015 OS Pid: 9040 executed alter system set events '10035 trace name context forever, off'