FACILITY

VARCHAR2(24)

Facility that encountered the event. Possible values are:

• CRASH RECOVERY
• LTS
• LAS
• RMS
• REMOTE FILE SERVER
• FETCH ARCHIVE LOG
• DATA GUARD
• NETWORK SERVICES

SEVERITY

VARCHAR2(13)

Severity of the event. Possible values are:

• INFORMATIONAL - informational message
• WARNING - warning message
• ERROR - indicates the process has failed
• FATAL
• CONTROL - an expected change in state such as the start or completion of an archival, log recovery, or switchover operation

DEST_ID

NUMBER

Destination ID number to which the event pertains. If the event does not pertain to a particular destination, then the value is 0.

MESSAGE_NUM

NUMBER

A chronologically increasing number giving each event a unique number

ERROR_CODE

NUMBER

Error ID pertaining to the event

CALLOUT

VARCHAR2(3)

Indicates whether the current entry is a callout event (YES) or not (NO)

A YES value in this column indicates that this event may require the DBA to perform some action. Examine the ERROR_CODE and MESSAGE columns for more information.

A NO value in this column generally corresponds to an INFORMATIONAL or WARNING event which would not require any action by the DBA.

TIMESTAMP

DATE

???

MESSAGE

VARCHAR2(256)

A text message describing the event