1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
  4. V$DIAG_SQL_TRACE_RECORDS

8.180 V$DIAG_SQL_TRACE_RECORDS

V$DIAG_SQL_TRACE_RECORDS contains all SQL_TRACE data that is present in the trace files that are part of the current Automatic Diagnostic Repository (ADR). This view also supports GV$ global views.

Column Datatype Description

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)

Displays 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