Re: PX Deq Credit: send blkd
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Fri, 29 Aug 2008 11:30:01 -0700
What event are the consumer slaves waiting on?
set linesize 150
col "Wait Event" format a30
select s.sql_id,
px.INST_ID "Inst",
px.SERVER_GROUP "Group",
px.SERVER_SET "Set",
px.DEGREE "Degree",
px.REQ_DEGREE "Req Degree",
w.event "Wait Event"
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;
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
