Oracle教程

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

本站中文解释

Oracle视图V$HANG_SESSION_INFO收集和显示在挂起会话期间可能会出现的信息。这个视图可以用来排查数据库出现的挂起会话的原因。通过查询这个视图，可以查看挂起会话的详细情况，以及执行操作可能会激活这个会话的相关信息（例如：等待的类型，等待的事件，等待的sql语句等）。使用这个视图，可以更加全面准确地排查挂起会话的原因。

官方英文解释

V$HANG_SESSION_INFO displays information about sessions involved in hangs described by V$HANG_INFO.

Each row with the same HANG_ID describes a session that is in the hang wait chain described by the row with the same HANG_ID in V$HANG_INFO. This session is blocked by the victim or final blocker of that hang.

Column Datatype Description

HANG_ID

NUMBER

A number identifying the hang including this session. This column can be used to join V$HANG_INFO with V$HANG_SESSION_INFO.

INSTANCE

NUMBER

Instance number of the instance on which this session resides

SID

NUMBER

Oracle session ID of this session

SERIAL#

NUMBER

Oracle session serial number of this session

OSPID

VARCHAR2(24)

Operating system process ID of this session

FATAL_BACKGROUND

VARCHAR2(1)

Y – Session is a critical background process

N – Session is not a critical background process

ROOT

VARCHAR2(1)

Y – This session is the victim or final blocker of the hang

N – This session is not the victim or final blocker of the hang

PNAME

VARCHAR2(5)

Name of the victim or final blocker process

PDB_ID

NUMBER

Oracle session’s container ID or PDB ID

WAIT_EVENT_TEXT

VARCHAR2(64)

Resource or event for which this session is waiting; set to not in a wait if the session is not waiting on a resource

WAIT_TIMEFoot 1

NUMBER

Time spent in wait for this session (in seconds). If the value of WAIT_EVENT_TEXT is not in a wait, then this column returns the number of seconds since the last wait.

QOS_PC_RANK

VARCHAR2(12)

Session’s Oracle Database Quality of Service (QoS) Management Performance Class rank

QOS_PC_ITT

NUMBER

Session’s Oracle Database Quality of Service (QoS) Management Performance Class In-Trouble Threshold

QOS_PC_RTT

NUMBER

Session’s Oracle Database Quality of Service (QoS) Management Performance Class Root Termination allowed Threshold

QOS_PC_KEY

NUMBER

Session’s Oracle Database Quality of Service (QoS) Management Performance Class Key

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

Footnote 1 This column is available starting with Oracle Database 21c.

See Also:

  • “V$HANG_INFO”

  • “V$HANG_STATISTICS”

  • “DBA_HANG_MANAGER_PARAMETERS”


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

相关推荐