ARCH wait on SENDREQ 等待事件
ARCH wait on SENDREQ
Cause
High ARCH wait on SENDREQ wait events found in statspack report.
"ARCH wait on SENDREQ" -- This wait event monitors the amount of time spent by
all archiver processes to write the received redo data to disk as well as open
and close the remote archived redo log files.This wait events can lead to a slow performance.
1)It means that there is a slow network between primary and standby database. -- 主備網路延遲比較大
2)It also means that there is a chance of slow performance on disk where remote --調整下磁碟
archiving is happening.
.
Solution
To implement the solution, please execute the following steps: --按照下面步驟進行排查
1.Please get in touch with your network admin and check the network response.
2.If the remote destination is slow and archiver is taking longer to archive to
that destination, then the user needs to allocate more redo log groups so that
there is a logfile available for a logswitch to switch into, and not wait for
the archiver to finish archiving to the destination.
3.One more workaround you can use is to set below parameter in primary site:
_LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE'
2.2.3 LNS wait on SENDREQ
All network servers to write the received redo data to disk as well as open and close the remote archived redo log files.
2.2.4 LNS wait on DETACH
All network servers to delete an RFS connection.
Cause
High ARCH wait on SENDREQ wait events found in statspack report.
"ARCH wait on SENDREQ" -- This wait event monitors the amount of time spent by
all archiver processes to write the received redo data to disk as well as open
and close the remote archived redo log files.This wait events can lead to a slow performance.
1)It means that there is a slow network between primary and standby database. -- 主備網路延遲比較大
2)It also means that there is a chance of slow performance on disk where remote --調整下磁碟
archiving is happening.
.
Solution
To implement the solution, please execute the following steps: --按照下面步驟進行排查
1.Please get in touch with your network admin and check the network response.
2.If the remote destination is slow and archiver is taking longer to archive to
that destination, then the user needs to allocate more redo log groups so that
there is a logfile available for a logswitch to switch into, and not wait for
the archiver to finish archiving to the destination.
3.One more workaround you can use is to set below parameter in primary site:
_LOG_ARCHIVE_CALLOUT='LOCAL_FIRST=TRUE'
2.2.3 LNS wait on SENDREQ
All network servers to write the received redo data to disk as well as open and close the remote archived redo log files.
2.2.4 LNS wait on DETACH
All network servers to delete an RFS connection.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29477587/viewspace-1128385/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 等待事件ARCH wait on ATTACH事件AI
- virtual circuit wait等待事件UIAI事件
- oracle wait event 等待事件OracleAI事件
- 等待事件 (wait event) [final]事件AI
- oracle virtual circuit wait 等待事件OracleUIAI事件
- buffer busy wait 等待事件說明AI事件
- cursor: pin S wait on X等待事件。AI事件
- log buffer space wait event等待事件AI事件
- buffer busy wait 等待事件說明(轉)AI事件
- 【WAIT】 log file sync等待事件說明AI事件
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- oracle等待事件之cursor:pin S wait on XOracle事件AI
- 常見的wait等待事件及處理AI事件
- cursor: pin S wait on X等待事件模擬AI事件
- 常見的wait等待事件及處理(zt)AI事件
- oracle等待事件型別wait_class說明Oracle事件型別AI
- 等待事件:wait for unread message on broadcast channel事件AIAST
- Oracle資料庫buffer busy wait等待事件 (2)Oracle資料庫AI事件
- Oracle資料庫buffer busy wait等待事件 (1)Oracle資料庫AI事件
- cursor: pin S wait on X等待事件模擬(轉)AI事件
- 【故障】cursor: pin S wait on X等待事件大量出現AI事件
- db file sequential read wait event等待事件之二AI事件
- 模擬產生CBC LATCH與buffer busy wait等待事件AI事件
- cursor: pin S wait on X等待事件的處理過程AI事件
- oracle11g_Descriptions of Wait Events_等待事件全列表OracleAI事件
- 轉載經典文章 buffer busy wait 等待事件說明AI事件
- 等待事件wait for a undo record 與 fast_start_parallel_rollback引數事件AIASTParallel
- Oracle10g等待事件型別wait_class說明Oracle事件型別AI
- wait等待事件及其處理方法 awr top5 報告AI事件
- [20130904]等待事件wait for a undo record.txt事件AI
- 【徵文】cursor: pin S wait on X等待事件的處理過程AI事件
- oracle11g_wait event等待事件及潛在原因列表OracleAI事件
- 查詢等待事件(wait event)相關的SQL - v$session_wait, v$rowcache,v$sqltext事件AISQLSession
- 【等待事件】ORACLE常見等待事件事件Oracle
- 【等待事件】等待事件系列(5.1)--Enqueue(佇列等待)事件ENQ佇列
- [20130904]等待事件wait for a undo record模擬.txt事件AI
- 啟動資料庫後,等待事件出現大量wait for undo record資料庫事件AI
- 等待事件事件