xychong123 发表于 2011-4-11 14:49:40

RAC节点 reliable message 等待事件!


EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
reliable message14,8160.99209140.08
control file sequential read530,8310.0010802.71
control file parallel write63,6340.006810.32
db file parallel write22,1920.005930.11
gc cr block 2-way35,4110.001600.18
CGS wait for IPC msg1,882,810100.001509.61
log file parallel write8,4680.001420.04
enq: WF - contention1,5100.26960.01
log file sync1060.007650.00
os thread startup2330.867290.00
gc current multi block request

reliable message 这个等待事件,是因为网络原因,还是CRS问题! 那这个等待事件怎么解决呢?

oraunix 发表于 2012-11-5 17:10:48

    When you send a message using the 'KSR' intra-instance broadcast
    service, the message publisher waits on this wait-event until
    all subscribers have consumed the 'reliable message' just sent.
   The publisher waits on this wait-event for three seconds and
    then re-tests if all subscribers have consumed the message, or
    until posted.
这是官方的解释,先确认是不是网络问题。
页: [1]
查看完整版本: RAC节点 reliable message 等待事件!