li
  当前位置:主页 > 性能优化 > 文章内容
li
"log file sync" 等待事件(3)
来源: www.ixdba.net  作者: IXDBA.NET官方    时间:2008-07-15   阅读:24  
本文章共4613字,分3页,当前第3页,快速翻页:
 

由于过渡频繁的提交,LGWR过度频繁的激活,我们看到这里出现了redo writing的latch竞争.

关于redo writing竞争你可以在steve的站点找到详细的介绍:
http://www.ixora.com.au/notes/lgwr_latching.htm


转引如下:

 

When LGWR wakes up, it first takes the redo writing latch to update the SGA variable that shows whether it is active. This prevents other Oracle processes from posting LGWR needlessly. LGWR then takes the redo allocation latch to determine how much redo might be available to write (subject to the release of the redo copy latches). If none, it takes the redo writing latch again to record that it is no longer active, before starting another rdbms ipc message wait.
If there is redo to write, LGWR then inspects the latch recovery areas for the redo copy latches (without taking the latches) to determine whether there are any incomplete copies into the log buffer. For incomplete copies above the sync RBA, LGWR just defers the writing of that block and subsequent log buffer blocks. For incomplete copies below the sync RBA, LGWR sleeps on a LGWR wait for redo copy wait event, and is posted when the required copy latches have been released. The time taken by LGWR to take the redo writing and redo allocation latches and to wait for the redo copy latches is accumulated in the redo writer latching time statistic.

(Prior to release 8i, foreground processes held the redo copy latches more briefly because they did not retain them for the application of the change vectors. Therefore, LGWR would instead attempt to assure itself that there were no ongoing copies into the log buffer by taking all the redo copy latches.)

After each redo write has completed, LGWR takes the redo allocation latch again in order to update the SGA variable containing the base disk block for the log buffer. This effectively frees the log buffer blocks that have just been written, so that they may be reused.



阅读更多内容<<上一页 · 1 · 2 · 3


  上一篇: Statspack ORA-00001 错误的解决   下一篇: oracle保护共享资源的锁定机制En...
li
 §相关评论  
 热点文章

·Resize datafile导致ASM Crash
·在Oracle10g RAC下新增ASM磁盘
·ORACLE SQL性能优化系列 (一)
·oracle性能调优:管理oracle日志
·oracle RAC环境中系统时钟的调
·why:Rac的心跳线不支持交叉线?
·RAC的VIP及实例依赖关系:版本O
·如何启动DataGuard的备用数据库
·系统表空间IO错误 数据损坏处理
·不幸中的万幸:遭遇ORA-00600 [
·用ORACLE的高级复制实现内外网
li
 编辑推荐
·Resize datafile导致ASM Crash
·在Oracle10g RAC下新增ASM磁盘
·ORACLE SQL性能优化系列 (一)
·oracle性能调优:管理oracle日志
·oracle RAC环境中系统时钟的调
·why:Rac的心跳线不支持交叉线?
·RAC的VIP及实例依赖关系:版本O
·如何启动DataGuard的备用数据库
·系统表空间IO错误 数据损坏处理
·不幸中的万幸:遭遇ORA-00600 [
·用ORACLE的高级复制实现内外网
li
 相关篇章
·Statspack ORA-00001 错误的解决
·db file scattered read-DB文件分...
·解决ORA-600 [qmxiUnpPacked2]错...
·什么是STATSPACK,我怎么使用
·如何获得所有的事件代码
·怎么样能固定自己的执行计划
·怎么样根据OS进程快速获得DB进程...
·怎样监控无用的索引
·怎么快速查找锁与锁等待
·怎么样快速重整索引
·oracle保护共享资源的锁定机制En...
·Oracle DBA 的 UNIX 袖珍参考手册...
·Oracle DBA 的 UNIX袖珍参考手册...
·Oracle DBA 的 UNIX 袖珍参考手册...
·Oracle DBA 的 UNIX 袖珍参考手册...
·Oracle DBA的UNIX袖珍参考手册之...
·Oracle DBA的UNIX袖珍参考手册之...
·Oracle DBA的UNIX 袖珍参考手册之...
·Oracle Server专有模式和共享模式...
·ORACLE SGA_MAX_SIZE与SGA_TARGE...
 
li
设为首页 | 关于我们 | 技术服务 | 收藏本站 | 网站地图 | 联系方式 | 本站友情连接