Oracle教程

Oracle 视图 V$DIAG_SESS_OPT_TRACE_RECORDS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$DIAG_SESS_OPT_TRACE_RECORDS用于查看当前会话的选项跟踪记录。它展示了与SESSION_TRACING_LEVEL设置有关的会话信息。这个视图包括以下信息：

1. SESSION_TRACING_LEVEL：会话跟踪级别，有OFF，LOW，MEDIUM，HIGH四种。
2. OPT_TRACE_START_TIMESTAMP：选项跟踪开始的时间戳。
3. OPT_TRACE_DURATION：前一级别选项跟踪持续的时间。
4. OPT_TRACE_FILENAME：保存有关选项跟踪数据的文件的名称。
5. OPT_TRACE_REC_COUNT：FIRED的跟踪记录数。

使用V$DIAG_SESS_OPT_TRACE_RECORDS视图时，需要根据需求使用一些过滤条件，如会话ID，用户名等，然后就可以查询出某一会话的相关选项跟踪信息了。例如：
SELECT SESSION_TRACING_LEVEL, OPT_TRACE_START_TIMESTAMP， OPT_TRACE_FILENAME
FROM V$DIAG_SESS_OPT_TRACE_RECORDS
WHERE SESSION_ID=’&your_session_id’;

以上查询语句就可以查询出指定会话ID所对应的跟踪级别、开始跟踪时间戳以及保存跟踪信息的文件名称。

官方英文解释

V$DIAG_SESS_OPT_TRACE_RECORDS contains all optimizer trace event data that is present in the trace files for the current user session that is part of the current Automatic Diagnostic Repository (ADR).

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


数据运维技术 » Oracle 视图 V$DIAG_SESS_OPT_TRACE_RECORDS 官方解释，作用，如何使用详细说明
分享到：

相关推荐