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

Last updated on MAY 04, 2017

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

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