Message in processed state not deleted from queue [message #176416] |
Thu, 08 June 2006 04:33 |
alvisemion
Messages: 4 Registered: June 2006
|
Junior Member |
|
|
My database is a cluster with 2 instance.
Version: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod
Property aq_tm_processes=0
Property job_queue_processes=10
My queue is
- multiconsumer
- without retention
Every message is enqueued:
without delay
Messages in state "PROCESSED" should be deleted from the queue table but they still remain
in the queue (time_manager_info is null for every one). In metalink i read that
time_manager_info is used by QMON process for message deleting; is it a problem if
time_manager_info is set to null for each message?
Should i check any configuration?
Why a non cluster database with the same application (same version + patchset)
always delete all processed messages?
Alvise
|
|
|