AQ dequeue message lost after session killed
edited Sep 18, 2012 11:30PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hello all,
I have an issue with DBMS_AQ.deQueue. When my session did a dequeue and is killed after that (before a commit or rollback), the particular message is permanently removed from the queue. I would expect it to still be in the queue, or at least be in the exception queue. I perform the following steps to test:
1. Enqueue from session 1, and commit. (see code below)
2. Dequeue from session 2. (see code below)
3. Session 1: select * from MY_Q_T -> my message is still visible here.
4. Session 2: select * from MY_Q_T -> my message is not visible anymore.
0