AQ 11gR2: DEQ_TIMESTAMP In AQ$ View Missing Using Multi Consumer AQ
Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms