Oracle教程

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

本站中文解释

视图是用来显示Oracle数据库及客户端收集的性能跟踪信息的。该视图基于Oracle数据库的$ORACLE_HOME/rdbms/trace目录下的文件，包括alert.log, listener.log, etc。数据库会自动在自己的目录下生成一系列的trace和跟踪文件，其中每个文件都代表一个不同数据库内部进程或会话 。比如$ ORACLE_HOME/rdbms/trace/ora_1772.trc代表ora_1772进程。

使用V$DIAG_OPT_TRACE_RECORDS视图，可以检查和跟踪当前连接活动。尤其是当你使用Oracle数据库时，你可以使用V$DIAG_OPT_TRACE_RECORDS查看哪些查询在你的会话运行超过一定时间，例如，你可以在V$DIAG_OPT_TRACE_RECORDS中过滤出消耗时间超过1秒的查询。

使用方法：第一个参数应该是确定要跟踪的进程ID，可以从V$PROCESS查找，第二个参数是我们要查询的时间，例如查询超过1秒的查询：

select p.sid, e.seconds_in_wait
from V$DIAG_OPT_TRACE_RECORDS p,V$SESSION_LONGOPS e
where p.event = ‘SQL*Net message from client’ and
e.sid = p.sid and
e.seconds_in_wait>1
order by p.sid;

官方英文解释

V$DIAG_OPT_TRACE_RECORDS contains all optimizer trace event 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)

Describes 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_OPT_TRACE_RECORDS 官方解释，作用，如何使用详细说明
分享到：

相关推荐