For 10g Release 2 (10.2)
Parameter type Integer
Default value 0
Modifiable ALTER SYSTEM
Range of values 0 to 10
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.