INCIDENT_ID

NUMBER

ID for the current incident

ADR_HOME

VARCHAR2(444)

Path to current ADR home

TRACE_FILENAME

VARCHAR2(68)

Displays the name of the process trace file

RECORD_LEVEL

NUMBER

Displays the level of the trace record

PARENT_LEVEL

NUMBER

Displays the top parent level of the trace record

RECORD_TYPE

NUMBER

Displays the type of the trace record. Possible values include:

• 1: Regular trace record

• 2: Freeform trace record

• 3: Begin Section trace record

• 4: Begin Dump trace record

• 5: Bucket Dump Begin trace record

• 6: Section End trace record

• 7: Dump End trace record

• 8: Bucket Dump End trace record

TIMESTAMP

TIMESTAMP(3) WITH TIME ZONE

Displays the timestamp when the trace record was produced

PAYLOAD

VARCHAR2(4000)

Describes the trace record payload (contents)

SECTION_ID

NUMBER

Displays the section ID / dump ID of the trace record

SECTION_NAME

VARCHAR2(64)

Displays the section name / dump name of the trace record

COMPONENT_NAME

VARCHAR2(64)

Displays the component name which produced the trace record

OPERATION_NAME

VARCHAR2(64)

Displays the operation name which produced the trace record

FILE_NAME

VARCHAR2(64)

Displays the name of the code file where this trace record is produced

FUNCTION_NAME

VARCHAR2(64)

Displays the function which produced this trace record

LINE_NUMBER

NUMBER

Displays the line number in the code file which produced this trace record

THREAD_ID

VARCHAR2(64)

Displays the operating system thread ID of the process which produced the trace record

SESSION_ID

NUMBER

Displays the user session ID which generated the trace record

SERIAL#

NUMBER

Displays the user session serial number which produced the trace record

SECURITY_LABEL

VARCHAR2(16)

Displays the trace record security label classification. Possible values:

• ALGORITHM

• CONFIG

• DATA

• INTERNAL

• KEYS

• METADATA

• NONE

• PROGRAM

• STATIC

• UNKNOWN

CON_UID

NUMBER

Displays the container unique ID where the trace record was produced

CONTAINER_NAME

VARCHAR2(64)

Displays the container name where the trace record was produced

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

• 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

• 1: This value is used for rows containing data that pertain to only the root

• n: Where n is the applicable container ID for the rows containing data