V$SESSION_WAIT
| | Identifier of the class of the wait event |
| | Number of the class of the wait event |
| | Name of the class of the wait event |
注釋:
WAIT_CLASS_ID
,表示該等待事件在整個等待事件這個範圍上的編号
WAIT_CLASS#
,表示該等待事件在該會話下的編号,即V$SESSION_WAIT視圖裡的第幾行
V$PX_SESSION
| | The logical group of servers to which this cluster database process belongs |
| | The logical set of servers to which this cluster database process belongs. A single server group will have at most two server sets. |
| | 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裡并行伺服器程序的編号。