Monday, November 3, 2008

AQ_TM_PROCESSES for 10gR2

For 10g Release 2 (10.2)

AQ_TM_PROCESSES
Property     Description
Parameter type     Integer
Default value     0
Modifiable     ALTER SYSTEM
Range of values     0 to 10
Basic     No

AQ_TM_PROCESSES enables time monitoring of queue messages.
The times can be used in messages that specify delay and expiration properties.
Values from 1 to 10 specify the number of queue monitor processes created to monitor the messages.
If AQ_TM_PROCESSES is not specified or is set to 0, then the queue monitor is not created.

The QMON processes are optional background processes for Oracle Streams Advanced Queueing (AQ) which monitor and maintain all the system and user owned AQ objects.
These optional processes, like the job_queue processes, does not cause the instance to fail on process failure.
They provide the mechanism for message expiration, retry, and delay, maintain queue statistics, remove processed messages from the queue table and maintain the dequeue IOT.

No comments:

Post a Comment