My Oracle Support Banner

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 11.2.0.1 and later
Information in this document applies to any platform.

Goal

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.



Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.