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

本站中文解释

V$DIAG_SQL_TRACE_RECORDS视图提供了accessed_instance_id列。这个列报告了每一个sql自上一次性能查询以来,在活动会话中执行的次数。它可以让DBA的查询结果自动存档起来,大大增加Oracle数据库支持和调试能力。同时还可以用来收集每一条SQL语句执行的统计信息,从而可以了解SQL语句执行的次数,平均时长等。

使用方法:

1.可以使用SELECT * FROM V$DIAG_SQL_TRACE_RECORDS;来查看当前会话的SQL跟踪记录。

2.可以使用SELECT * FROM V$DIAG_SQL_TRACE_RECORDS WHERE accessed_instance_id = ;来查看某一特定实例的SQL跟踪记录。

官方英文解释

V$DIAG_SQL_TRACE_RECORDS contains all SQL_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

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_SQL_TRACE_RECORDS 官方解释,作用,如何使用详细说明