CPU TIME "dbms_aqin.aq$_dequeue_in"

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Fri, 12 Aug 2005 12:18:56 -0500
Message-ID: <1F989681BA05FA4CAD9FA849ED852057B0C2C5@pscdalpexch01.perotsystems.net>

Take a snapshot of SQLAREA, check back a bit later and frequently see some very high elap times on advanced queue related things. These procs do create occasion bursts of logical IO, but nothing that would account for such a high elap time. This is a delta, not a cumulative number. Anyone know if this is a bug?

---

---

        elap          cpu    disk  buffer         sort        fetch
exe        parse         rows

------------ ------------ ------- ------- ------------ ------------ ------------ ------------ ------------

begin dbms_aqin.aq$_dequeue_in( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :1 9, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29); end;

     2646.27          .16      39   41636          .00          .00
5645.00      5661.00         3.00

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 12 2005 - 12:21:12 CDT