8.173 V$DIAG_APP_TRACE_FILE

V$DIAG_APP_TRACE_FILE contains information about all trace files present in the Automatic Diagnostic Repository (ADR) for the current container (PDB) which contain application trace data (SQL_TRACE or OPTIMIZER_TRACE event data). This view also supports GV$ global views.

Column Datatype Description

ADR_HOME

VARCHAR2(444)

Path to the current ADR home

TRACE_FILENAME

VARCHAR2(68)

Displays the name of the process trace file

CHANGE_TIME

TIMESTAMP(3) WITH TIME ZONE

Displays the change time timestamp of the process trace fiile

MODIFY_TIME

TIMESTAMP(3) WITH TIME ZONE

Displays the last modification timestamp of the process trace file

SQL_TRACE

VARCHAR2(1)

Identifies if the process trace file contains SQL_TRACE data. Possible values include:

  • Y: This value is used when the process trace file contains SQL_TRACE event data

  • N: This value indicates that the process trace does not contain SQL_TRACE data

OPTIMIZER_TRACE

VARCHAR2(1)

Identifies if the process trace file contains OPTIMIZER_TRACE data. Possible values include:

  • Y: This value is used when the process trace file contains OPTIMIZER_TRACE event data

  • N: This value indicates that the process trace does not contain OPTIMIZER_TRACE data

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