oracle WARNING: AQ_TM_PROCESSES is set to 0

in alert log <<<<
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Completed: ALTER DATABASE OPEN



as per metalink 428441.1




SQL> declare
2 mycheck number;
3 begin
4 select 1 into mycheck from v$parameter where name = 'aq_tm_processes' and value = '0'
5 and (ismodified <> 'FALSE' OR isdefault='FALSE');
6 if mycheck = 1 then
7 dbms_output.put_line('The parameter ''aq_tm_processes'' is explicitly set to 0!');
8 end if;
9 exception when no_data_found then
10 dbms_output.put_line('The parameter ''aq_tm_processes'' is not explicitly set to 0.');
11 end;
12 /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
The parameter 'aq_tm_processes' is explicitly set to 0!

PL/SQL procedure successfully completed.


conn / as sysdba


SQL> alter system set aq_tm_processes = 1 scope=spfile ;

System altered.



re start database then check the value


SQL> col TYPE format a15
set linesize 200


SQL> show parameter aq_tm_processes

NAME TYPE VALUE
------------------------------------ --------------- ------------------------------
aq_tm_processes integer 1