Oracle教程

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

本站中文解释

Oracle视图V$DIAG_SESS_SQL_TRACE_RECORDS通常用来收集用户会话的SQL跟踪记录和性能调配的信息。它的最小记录开始时间决定当前会话结束时间，由v$diag_sess_trace.trace_cursor_end时间确定，最大记录完成时间由v$diag_sess_sql_trace_records.sql_finish_time确定。这个视图的主要用途是帮助管理员跟踪和记录他们的数据，即系统性能参数、实用SQL跟踪及自定义性能指标等。

使用V$DIAG_SESS_SQL_TRACE_RECORDS视图，可以收集多个会话对应的SQL话语跟踪信息，以及处理过程信息。通过查询这个视图，可以获得Oracle会话的SQL操作、解析和SGA登录状态的详细统计信息。

一般流程：

1、将v$diag_sess_sql_trace_records表中的curses_id、session_id、username这3个字段分别赋值给变量。

2、通过查询v$diag_sess_sql_trace_records表并将session_id字段与变量对比，获取符合条件的所有数据。

3、通过查询v$diag_sess_sql_trace_records表，并将username字段与变量对比，获取符合条件的所有数据。

4、检索候选结果，根据v$diag_sess_sql_trace_records表中的sql_finish_time字段，列出执行过的SQL语句。

5、关闭会话，然后查询V$diag_sess_sql_trace_records表，获取最新的跟踪记录和性能调整信息。

官方英文解释

V$DIAG_SESS_SQL_TRACE_RECORDS contains all SQL_TRACE 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_SQL_TRACE_RECORDS 官方解释，作用，如何使用详细说明
分享到：

相关推荐