Streams AQ: qmn coordinator waiting for slave to start

xifenfei

数据库版本：10.2.0.5，运行平台power linux

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
control file sequential read	25,393	11	0	455.7	System I/O
Streams AQ: qmn coordinator waiting for slave to start	2	10	4,883	388.5	Other
CPU time		4		152.2
control file parallel write	3,625	3	1	129.3	System I/O
reliable message	815	1	1	48.5	Other

数据库出现大量Streams AQ: qmn coordinator waiting for slave to start等待


进一步分析发现AQ_TM_PROCESSES 设置为0


官方建议该值最少设置为1，否则数据库会一直尝试启动aq，但是因为参数配置为0，不能启动，所以出现该等待




强力建议AQ_TM_PROCESSES  不要设置为0   目前发现在10205中引起Streams AQ: qmn coordinator waiting for slave to start非常明显

cargoo

雁过留声