Document toolboxDocument toolbox

sp419_event_audit

Owned by Jason Andrew
Oct 02, 2024

Records the events reported to the OS system log by the System Monitor. It is only populated if the sp083_system_parameters entry "mon_audit_events" is set to "YES". 

 

 

Housekeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
sequence_nonumber(9) (error)
timestampdate (error)
monitor_nonumber (error)
message_typenumber(9) (error)
messagevarchar2(256) (error)

Keys

foreign key (monitor_no) references sp406_monitors(component_no)

Column Descriptions

FieldDescription
sequence_no Unique identifier: the sequence number of the update.
timestampDate and time the event was generated (Uses the time zone of the DBMS server machine). 
monitor_noComponent number of the system monitor that generated the event.
message_type

The type of event:

0 = Information

1 = Warning

2 = Error 

message The textual description of the event.