oracle诊断事件

提供一个简单获取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  /

 

内容类似：

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博客 ” ，链接：http://blog.itpub.net/25618347/viewspace-743775/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25618347/viewspace-743775/