Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AQ - Message state not updated on queue table

User_A0ZGWMar 21 2019 — edited Mar 22 2019

Hello all,

The message state is not getting updated to 2 on queue tables even though message is processed (state remains 0). The correct state is available on the AQ$ views. We'd encountered this behaviour two days back. Functionality is not impacted, however, I'd like to understand if we could potentially have some issues if state does not get updated on queue tables.

We are on DB 11.2.0.3.0.

Regards,

Nagendra

Comments

Post Details

Added on Mar 21 2019
4 comments
2,236 views