Oracle 视图 V$DIAG_TRACE_FILE_CONTENTS 官方解释，作用，如何使用详细说明
本站中文解释
V$DIAG_TRACE_FILE_CONTENTS视图是Oracle数据库中的一个特殊视图，用于查询诊断跟踪文件的内容。它提供了一个方便的方法，Step1：连接到Oracle数据库，Step2：执行以下查询：
SELECT text from V$DIAG_TRACE_FILE_CONTENTS;
Step3：查询结果就是诊断跟踪文件的内容，它可以帮助你更好的理解Oracle数据库的工作原理和问题分析。
官方英文解释
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 trace record security label classification. Possible values:
|
|
|
|
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:
|
