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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2

Post Details

Added on Mar 21 2019
4 comments
2,122 views