Oracle Diagnostic Events

Oracle Diagnostic Events

NOTE:
The events are listed as regular Oracle ORA- errors but are no actual errors (except for some specific test error).

These events are partly listed in the 11.2 Oracle® Database Error Messages guide and are returned by the Oracle 'oerr' utility, e.g.
  $ oerr ora 10000
  10000, 00000, "control file debug event, name 'control_file'"
  // *Document: NO
  // *Cause:
  // *Action:

However, because these are (mostly real) events and no actual errors, it is not possible to use these 'error' numbers with an errorstack event.
The event need to be set using "trace name context", e.g.
SQL> alter session set events '10046 trace name context forever, level 12';

DETAILS

SQL> SET linesize 120
SQL> SET feedback off
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
  6  LOOP
  7  err_msg := SQLERRM (-err_num);
  8  IF err_msg NOT LIKE '%Message '||err_num||' not found%' THEN
  9  dbms_output.put_line (err_msg);
 10  END IF;
 11  END LOOP;
 12  END;
 13  /