Intermittently PROCESSED Messages Are Not Removed from Queue Tables by the QMON Processes (Doc ID 752708.1)

Last updated on NOVEMBER 04, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
HP-UX Itanium



Symptoms

Intermittently PROCESSED messages are not being removed from queue tables.

Attaching to the qmon processes via oradebug and generating an errorstack causes the PROCESSED messages to be removed. Stack trace generated matches that in <Note:580273.1>.

Additionally issuing

alter system set aq_tm_processes=0 scope=memory;

and

alter system set aq_tm_processes=1 scope=memory;

restarts the qmon slave process and temporarily works around the issue.

The problem is only observed on the HP-UX Itanium port.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms