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