天天看點

對視圖V$SESSION_WAIT和V$PX_SESSION的部分字段解釋V$SESSION_WAITV$PX_SESSION

V$SESSION_WAIT

WAIT_CLASS_ID

NUMBER

Identifier of the class of the wait event

WAIT_CLASS#

NUMBER

Number of the class of the wait event

WAIT_CLASS

VARCHAR2(64)

Name of the class of the wait event

注釋:

WAIT_CLASS_ID

,表示該等待事件在整個等待事件這個範圍上的編号

WAIT_CLASS#

,表示該等待事件在該會話下的編号,即V$SESSION_WAIT視圖裡的第幾行

V$PX_SESSION

SERVER_GROUP

NUMBER

The logical group of servers to which this cluster database process belongs

SERVER_SET

NUMBER

The logical set of servers to which this cluster database process belongs. A single server group will have at most two server sets.

SERVER#

NUMBER

The logical number of the cluster database process within a server set

注釋:

一個并行查詢可以由多個DFO tree組成,一個DFO tree對應為一個group(即V$PX_SESSION視圖中的

SERVER_GROUP

字段),一個group則由多個set(即V$PX_SESSION視圖中的

SERVER_SET

字段)組成,一個group至多由2個set構成。

SERVER#

,表示一個set裡并行伺服器程序的編号。

繼續閱讀