博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
【DATAGUARD】Data Guard Wait Events
阅读量:6264 次
发布时间:2019-06-22

本文共 3355 字,大约阅读时间需要 11 分钟。

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.

转载地址:http://vbupa.baihongyu.com/

你可能感兴趣的文章
Mybatis+mysql动态分页查询数据案例——配置映射文件(HouseDaoMapper.xml)
查看>>
poj 2828【线段树 单点更新】
查看>>
java构建二叉树和二叉树的遍历
查看>>
svn+jenkins+docker 发布 java 项目(maven)
查看>>
一步一步学NUnit(1)
查看>>
android开发
查看>>
1027 方程组的根
查看>>
菜鸟网络股权分配:阿里巴巴占51%的股份
查看>>
《Pro SQL Server Internals》部分翻译(P36-P45)
查看>>
菜鸟nginx源代码剖析数据结构篇(十) 自旋锁ngx_spinlock
查看>>
广州高清卫星地图 用百度卫星地图server下载 含标签、道路数据叠加 可商用
查看>>
mysql手记
查看>>
JAVA 不同类载入器命名空间的理解
查看>>
数据库恢复之丢失联机重做日志文件的恢复
查看>>
C#发邮件
查看>>
3_1 wp8应用生命周期与导航事件[wp8特色开发与编程技巧]
查看>>
读取表结构到变量中
查看>>
SQL Server安全 2:身份验证
查看>>
算法集锦(二)
查看>>
ThinkPHP5 公共函数
查看>>