Defines trace levels that can be in effect in the ServiceOptimizer diagnostic logs.

These trace levels are combined in trace masks (see sp412_trace_masks).

Table Definition

Field	Type	Default	Nullable
name	varchar2(20)
description	varchar2(100)
trace_level	number(9)

Keys

primary key (trace_level)
unique (name)

Field	Description
name	Unique name for the trace level. This is included in each diagnostic log message.
description	Textual description of the trace level.
trace_level	Numeric identifier for the trace level. When combined in a bit mask, this is the bit number where trace_level 0 is the lowest bit.

Name	Description	Trace Level	Equivalent Bit Value
FATAL_ERROR	Unrecoverable error: process will terminate	0	0x1
UNEXPECTED_ERROR	Unexpected but recoverable condition requiring investigation	1	0x2
EXPECTED_ERROR	Expected, recoverable conditions that cause an operation to fail	2	0x4
WARNING	Expected, recoverable conditions that may require investigation	3	0x8
INFORMATION	Progress messages	4	0x10
DEBUG1	Advisory diagnostic progress messages	6	0x40
DEBUG2	Detailed diagnostic progress messages	7	0x80
DEBUG3	Technical, low-level diagnostic progress messages	8	0x100
PROTOCOL	Incoming and outgoing messages	9	0x200
HEARTBEAT	Incoming and outgoing heartbeat messages	10	0x400
ABS_SEARCH	ABS search processing	11	0x800
SOAP	SOAP API processing in API Agent	12	0x1000
OPTIMIZER	Optimizer processing	13	0x2000
DATABASE	Database query	14	0x4000
DEPENDENCIES	ABS dependency group processing	15	0x8000

Selecting ALL tracing can be achieved by using a trace_level of 0x1FFFF

Name	Description	Trace Level	Equivalent Bit Value
DUMP	Detailed diagnostic messages about Job layout - for use by Server Developers/Testers	16	0x10000
RTTP2P	Diagnostic messages for P2P and RTT travel time update systems	17	0x20000