7.179 V$DIAG_TRACE_FILE_CONTENTS
V$DIAG_TRACE_FILE_CONTENTS
contains 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 |
---|---|---|
|
|
Path to the current ADR home |
|
|
Displays the name of the process trace file |
|
|
Displays the level of the trace record |
|
|
Displays the top parent level of the trace record |
|
|
Displays the type of the trace record. Possible values include:
|
|
|
Displays the timestamp when the trace record was produced |
|
|
Displays the trace record payload (contents) |
|
|
Displays the section ID / dump ID of the trace record |
|
|
Displays the section name / dump name of the trace record |
|
|
Displays the component name which produced the trace record |
|
|
Displays the operation name which produced the trace record |
|
|
Displays the name of the code file where this trace record is produced |
|
|
Displays the function which produced this trace record |
|
|
Displays the line number in the code file which produced this trace record |
|
|
Displays the operating system thread ID of the process which produced the trace record |
|
|
Displays the user session ID which generated the trace record |
|
|
Displays the user session serial number which produced the trace record |
|
|
Displays the container unique ID where the trace record was produced |
|
|
Displays the container name where the trace record was produced |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).