zz$log

From zzat
Jump to: navigation, search

zz$log is zztat's central logging table. Join the table with zz$facility to get the human-readable definition of the facility and module.

It has the following columns:

Column Name Data Type Description
ts timestamp_with_local_time_zone Timestamp of the event
sev number Severity. 0=INFO, 1=WARN, 2=ERROR
facility# number Facility as per zz$facility.facility#.
module# number Module as per zz$facility.module#.
error# number Oracle error number.
text varchar2 Message text.
stack varchar2 If error# != 0, this contains the PL/SQL call stack (Oracle 12.1+).