My Oracle Support Banner

Advanced Queues Create New AQ$_HEAL_NTFN_ Job When Not Expected And Tries To Process Next Message (Doc ID 2829672.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


There is a queue that will send a message to another system via http. It will not commit the dequeue until success or it hits timeout limit.
When retry for more than an hour, a additional dbms_scheduler job type like AQ$_HEAL_NTFN_ is spawned after about every 40 minutes which causes a second message to be dequeued.
This cause issues as the first message is still waiting to send from the PLSQL. This can lead to messages out of sync.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.