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:

Symptoms

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.

Changes

Cause

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