Oracle AQ Leave stale Subscribers in the Queue
We are using Oracle AQ(Advanced Queue) in our project. We see messages and subscribers keep accumulating in our AQ Queue table. It's not clear to us why there are so many subscribers and get into the error:
Caused by: oracle.jms.AQjmsException: ORA-24067: exceeded maximum number of subscribers for queue FUSION.FND_JMS_EXMR_QUEUE