Data Guard Wait Events
This note describes the wait events that monitor the performance of the log transport modes that were specified on the primary database with the ARCH, LGWR, SYNC, and ASYNC attributes on the LOG_ARCHIVE_DEST_n initialization parameter. The wait events and associated timing information are displayed by the V$SYSTEM_EVENT view, as follows: Wait events for standby destinations configured with the ARCH attribute: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "ARCH wait on ATTACH" This wait event monitors the amount of time spent by all archiver processes to spawn an RFS connection. "ARCH wait on SENDREQ" This wait event monitors the amount of time spent by all archiver processes to write the received redo to disk as well as open and close the remote archived redo logs. "ARCH wait on DETACH" This wait event monitors the amount of time spent by all archiver processes to delete an RFS connection. Wait events for standby destinations configured with the LGWR SYNC attributes: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "LGWR wait on ATTACH" This wait event monitors the amount of time spent by all log writer processes to spawn an RFS connection. "LGWR wait on SENDREQ" This wait event monitors the amount of time spent by all log writer processes to write the received redo to disk as well as open and close the remote archived redo logs. "LGWR wait on DETACH" This wait event monitors the amount of time spent by all log writer processes to delete an RFS connection. Wait events for standby destinations configured with the LGWR ASYNC attributes: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "LNS wait on ATTACH" This wait event monitors the amount of time spent by all network servers to spawn an RFS connection. "LNS wait on SENDREQ" This wait event monitors the amount of time spent by all network servers to write the received redo to disk as well as open and close the remote archived redo logs. "LNS wait on DETACH" This wait event monitors the amount of time spent by all network servers to delete an RFS connection. "LGWR wait on full LNS buffer" This wait event monitors the amount of time spent by the log writer (LGWR) process waiting for the network server (LNS) to free up ASYNC buffer space. If buffer space has not been freed in a reasonable amount of time, availability of the primary database is not compromised by allowing the archiver process (ARCn) to transmit the redo log data. This wait event is not relevant for destinations configured with the LGWR SYNC=PARALLEL attributes. Wait events for standby destinations configured with either the LGWR ASYNC or LGWR SYNC=PARALLEL attributes: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "LGWR wait on LNS" This wait event monitors the amount of time spent by the log writer (LGWR) process waiting to receive messages on KSR channels from the network server. "LNS wait on LGWR" This wait event monitors the amount of time spent by the network server waiting to receive messages on KSR channels from the log writer (LGWR) process. "LGWR-LNS wait on channel" This wait event monitors the amount of time spent by the log writer (LGWR) process or the network server processes waiting to receive messages on KSR channels.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8484829/viewspace-2118201/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【DATAGUARD】Data Guard Wait EventsAI
- wait eventsAI
- Oracle RAC Wait EventsOracleAI
- Parallel Query Wait EventsParallelAI
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- 幾個ORACLE wait eventsOracleAI
- DATA GUARD部署模式——DATA GUARD概念和管理模式
- 介紹ORACLE DATA GUARD——DATA GUARD概念和管理Oracle
- Data guard搭建
- oracle data guard!!Oracle
- High "Resmgr:Cpu Quantum" Wait EventsAI
- 轉:latch wait events 說明分析AI
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- Data Guard Broker系列之二:Data Guard Broker配置實戰
- DATA GUARD 簡介
- Data Guard 建立(ASM)ASM
- Oracle Data Guard配置Oracle
- Oracle 11g Data Guard Enabling Active Data GuardOracle
- [Data Guard]Oracle10g Data Guard學習筆記(一)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(二)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(三)Oracle筆記
- zt_關於wait events asynch descriptor resize_wait eventAI
- Buffer Cache I/O-Related Wait EventsAI
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- Oracle Data Guard Broker元件Oracle元件
- Oracle Data Guard簡介Oracle
- 單機搭建Data Guard
- Active Data Guard初探(一)
- DATA GUARD架構(一)架構
- Oracle Data Guard 介紹Oracle
- physical data guard 的原理
- ORACLE Data Guard--IOracle
- data guard switchover on solaris 10
- wait event_Additional Statistics_that do not have corresponding wait eventsAI
- oracle中 Wait Events 和可能原因(oracle doc)OracleAI
- 技術白皮書:Oracle Data Guard 11gOracle Data Guard 理論知識OracleGo