【故障-ORACLE】rdbms ipc message timeout解釋

路途中的人2012發表於2016-10-08
Oracle

sys@GZKNEW_SQL> select sid,event,P1TEXT,state from v$session_wait where event not in ('SQL*Net message from client');

 

    SID EVENT                          P1TEXT                         STATE

------- ------------------------------ ------------------------------ -------------------

…………………………………………

   2719 rdbms ipc message              timeout                        WAITING

   2720 rdbms ipc message              timeout                        WAITING

   2724 rdbms ipc message              timeout                        WAITING

   2725 ASM background timer                                          WAITING

   2729 rdbms ipc message              timeout                        WAITING

   2731 rdbms ipc message              timeout                        WAITING

   2733 rdbms ipc message              timeout                        WAITING

…………………………………………

透過以上sql查詢到大量rdbms ipc message timeout等待，此事件是空閒事件，解釋如下：

The background processes (LGWR, DBWR, LMS0) use this event to indicate that they are idle and are waiting for the foreground processes to send them an IPC message to do some work.

Wait Time: Up to 3 seconds. The parameter timeout shows the true sleep time.

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29067253/viewspace-2125932/，如需轉載，請註明出處，否則將追究法律責任。

相關文章