提供一个简单获取oracle诊断事件的方法，如下：
SQL> set line 250
SQL> set serveroutput on
SQL> declare
2 err_msg varchar2(120);
3 begin
4 dbms_output.enable(1000000);
5 for err_num in 10000..10999 loop
6 err_msg :=sqlerrm(-err_num);
7 if err_msg not like '%Message '||err_num||' not found%' then
8 dbms_output.put_line(err_msg);
9 end if;
10 end loop;
11 end ;
12 /
SQL> set serveroutput on
SQL> declare
2 err_msg varchar2(120);
3 begin
4 dbms_output.enable(1000000);
5 for err_num in 10000..10999 loop
6 err_msg :=sqlerrm(-err_num);
7 if err_msg not like '%Message '||err_num||' not found%' then
8 dbms_output.put_line(err_msg);
9 end if;
10 end loop;
11 end ;
12 /
内容类似：
ORA-10000: control file debug event, name 'control_file'
ORA-10001: control file crash event1
ORA-10002: control file crash event2
ORA-10003: control file crash event3
ORA-10004: block recovery testing - internal error
ORA-10005: trace latch operations for debugging
ORA-10006: block recovery testing - external error
ORA-10007: log switch debug crash after new log select, thread
ORA-10008: log switch debug crash after new log header write, thread
ORA-10009: log switch debug crash after old log header write, thread
ORA-10010: Begin Transaction
ORA-10011: End Transaction
ORA-10012: Abort Transaction
.......
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25618347/viewspace-743775/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
