My Oracle Support Banner

<Bug:8810257> Expensive Dequeue From A Commit-Time Ordered Queue Table (Doc ID 1165289.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Information in this document applies to any platform.


Dequeue performance from a persistent commit_time ordered queue degrades as the transaction size decreases in

This occurs when using the JMS or PL/SQL API.

The resource consuming sql is of the form

select enq_tid
"<SCHEMA-NAME>"."AQ$_<QUEUE-TABLE-NAME>_C" ctiot where enq_tid in (select msg_enq_tid
from "<SCHEMA-NAME>"."AQ$_<QUEUE-TABLE-NAME>_I" qidx1 where qidx1.subscriber# = :1 and = :2 and qidx1.queue# = :3) and ctiot.cscn >= :4 and
ctiot.cscn < :5 order by cscn, enq_tid

The number of buffer gets associated with this query increases as the transactional size decreases.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.