zz$facility

From zzat
Jump to: navigation, search

zz$facility stores identifiers used for logging purposes and can be used to map the data in zz$log to more meaningful names.

It has the following columns:

Column Name Data Type Description
facility# number Identifies the facility (most of the time this will be the zztat package name). Used in zz$log
module# number Identifies the module (most of the time this will be the procedure name of the package). Used in zz$log
facility varchar2 The name of the facility
module varchar2 The name of the module
debug varchar2 If the facility/module has debug mode enabled
trace varchar2 If the facility/module has SQL trace enabled
trace_level number The level to use when tracing
instrumented varchar2 Indicates whether the module supports self-trace