Home » Server Options » Streams & AQ » Message in processed state not deleted from queue
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
Previous Topic: 'Insufficient privileges' enque JMS ObjectMessage to owned by different usr
Next Topic: Advanced queue don't dequeue - v$session v$lock
Goto Forum:
  


Current Time: Thu Mar 28 03:19:09 CDT 2024