Queue Monitor Auto-Tuning only uses 1 Qmon Slave Process for Persistent Queues (Doc ID 809383.1)

Last updated on JULY 16, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

In 10.1 onwards, when using the auto-tuning algorithm of the qmon slave processes, only 1 qmon slave process ever handles persistent queues by default.

This can result in a backlog of PROCESSED messages which are not removed in a timely manner with or without retention being used. In turn this can result in excessive storage consumption.

If enqueue sessions are stopped the PROCESSED messages are removed. In other words the messages are suitable candidates for removal and are just not being removed quickly enough.

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