ORA-1002 DURING SHARDED QUEUE OPERATIONS IN XA TRANSACTION ENVIRONMENT
(Doc ID 2747086.1)
Last updated on MARCH 08, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
ORA-1002 occurrs on 1st dequeue attempt after commit/End/Detach of previous dequeue/s transaction, in XA transaction environment.
When a queue shard is reported as UNCACHED in gv$aq_message_cache, the ORA-1002 appears.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document