<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 10.2.0.1 to 10.2.0.4 [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 10.2.0.4.
This occurs when using the JMS or PL/SQL API.
The resource consuming sql is of the form
"<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
qidx1.name = :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