xifenfei 发表于 2014-3-20 21:17:23

Streams AQ: qmn coordinator waiting for slave to start

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

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
control file sequential read25,393110455.7System I/O
Streams AQ: qmn coordinator waiting for slave to start2104,883388.5Other
CPU time4152.2
control file parallel write3,62531129.3System I/O
reliable message8151148.5Other
数据库出现大量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 发表于 2014-12-8 13:17:40

雁过留声
页: [1]
查看完整版本: Streams AQ: qmn coordinator waiting for slave to start