My Oracle Support Banner

AQ 11gR2: DEQ_TIMESTAMP In AQ$ View Missing Using Multi Consumer AQ (Doc ID 2089487.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


We are using Oralce ESB. This product uses AQ based JMS Topics. The AQs are multiconsumer AQs. For Reporting we have retention time > 0 and query enqueue and dequeue timestamps in AQ$ views. In 10gR2 and 11gR1 Databases this works fine. After upgrading to database 11gR2 the DEQ_TIMESTAMP disappears from AQ$ view.


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.