AQ 11gR2: DEQ_TIMESTAMP In AQ$ View Missing Using Multi Consumer AQ
(Doc ID 2089487.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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!