パラレル実行のパフォーマンスの監視 - VLDBおよびパーティショニング・ガイド 11g リリース2 (11.2) [Oracle Database] B56316-03 http://docs.oracle.com/cd/E16338_01/server.112/b56316/parallel006.htm#i1008510

gistfile1.txt

SELECT px.SID "SID", p.PID, p.SPID "SPID", px.INST_ID "Inst",
       px.SERVER_GROUP "Group", px.SERVER_SET "Set",
       px.DEGREE "Degree", px.REQ_DEGREE "Req Degree", w.event "Wait Event"
       ,w.seconds_in_wait
       ,w.p1text
       ,w.p1
       ,w.p2text
       ,w.p2
       ,w.p3text
       ,w.p3
FROM GV$SESSION s, GV$PX_SESSION px, GV$PROCESS p, GV$SESSION_WAIT w
WHERE s.sid (+) = px.sid AND s.inst_id (+) = px.inst_id AND
      s.sid = w.sid (+) AND s.inst_id = w.inst_id (+) AND
      s.paddr = p.addr (+) AND s.inst_id = p.inst_id (+)
ORDER BY DECODE(px.QCINST_ID,  NULL, px.INST_ID,  px.QCINST_ID), px.QCSID,
DECODE(px.SERVER_GROUP, NULL, 0, px.SERVER_GROUP), px.SERVER_SET, px.INST_ID