Re: PX Deq Credit: send blkd

From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 29 Aug 2008 11:30:01 -0700
Message-ID: <a9c093440808291130k6b52a561xd3dc7b18530430a0@mail.gmail.com>

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
--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 29 2008 - 13:30:01 CDT