Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CPU TIME "dbms_aqin.aq$_dequeue_in"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US