GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center