Queue Is Not Dequeued And Got Stuck As No QMON Running
(Doc ID 2440796.1)
Last updated on AUGUST 18, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Queue is not dequeued and got stuck.
No qmon (i.e qmn, q00*) processes at OS level observed, even after database restarted
Even we tried to set aq_tm_processes to 0 and than 1 or 5, but not helping.
Bounced the database and even host but not helping
Also observed AQPC process was started once instance started, but it gone between
database mount and open. But it took around 10 min for opening database after mount
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