AQ_TM_PROCESSES

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

AQ_TM_PROCESSES controls time monitoring on queue messages and controls processing of messages with delay and expiration properties specified.You do not need to specify a value for this parameter because Oracle Database automatically determines the number of processes and autotunes them, as necessary. Therefore, Oracle highly recommends that you leave the AQ_TM_PROCESSES parameter unspecified and let the system autotune.

Note:

1. If you want to disable the Queue Monitor Coordinator, then you must set AQ_TM_PROCESSES to 0 in your parameter file. Oracle strongly recommends that you do NOT set AQ_TM_PROCESSES to 0. If you are using Oracle Streams, then setting this parameter to zero (which Oracle Database respects no matter what) can cause serious problems.

2. A number of internal database features rely on the AQ_TM_PROCESSES having a value other than 0 so explicitly setting this parameter to 0 can lead to some features appearing not to work as expected. In 10.2 a warning is written to the alert if this parameter has been set to 0 – See Metalink Note 428441.1

3. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = 'AQ_TM_PROCESSES';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
aq_tm_processes	1	FALSE	FALSE	IMMEDIATE	TRUE	FALSE	number of AQ Time Managers to start

Oracle initializatoin parameters