V$AQ View Showing Incorrect Value On Column "READY" (same issue described in Doc ID 1057026.1)
Hello,
I have an Oracle Database 19c patched to version 19.10.0.0.210119 and I have the same problem described in Doc ID 1057026.1 for Version 10.2.0.2 to 10.2.0.4.
Is there any bug for 19c not documented? do you know if there is a workaround to try to solve this?
When I select on V$AQ I see 2950 messages in READY state but if I go to my AQ$QUEUETABLE, where I have my "LIVE" messages, I only see one or two at the most.
Could you please help me?
Thanks in advance.