- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
2 queues with listener, 1 works the other is hanged
I am building a small solution enqueueing messages (which is working fine) in 2 queues as "types" of messages and payloads.
To consume (dequeue) the messages I am using a procedure using an Agent and dbms_aq.listen.
To listen for new messages, I have a scheduled job that runs every (say) 10 mins, and my listening loop only runs for 10mins.
I have 2 of these, one for each queue.
My problem is that when I enqueue a message for each one, the first sched-job-listener will work fine, but the other one will not pick up the new message until it restarts. It is like the 2 queues are not being consumed at the same time.
Anyone ever seen anything like this?