Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Dequeue issue

sanjiv chowdhuryMay 19 2025 — edited May 19 2025

Hello all,

Database version : 19C

We are enqueuing 2 messages in almost same time, but when dequeue is happening , 2nd enqueuing msg is dequeuing before 2nd one.

Queue table created with ENQ_TIME sort option. No priority mentioned in Queue , but all the msg is priority 1.

Sample: 

Msg       Enq_Time                            DEQ_Time 
123 19/05/2025 14:20:45 51254545    19/05/2025 14:20:45 59254545 
456 19/05/2025 14:20:45 56254545    19/05/2025 14:20:45 58254545 
Comments
Post Details
Added on May 19 2025
15 comments
353 views