LGWR TRACE Warning: log write time-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

LGWR TRACE Warning: log write time

简介:
同学们大概偶尔也会在事务繁忙的Oracle数据库的LGWR日志进程的TRACE里找到如下的内容:
Warning: log write time 1730ms, size 155KB
*** 2011-09-12 22:56:05.407
Warning: log write time 810ms, size 1KB
*** 2011-09-12 22:56:06.990
Warning: log write time 1590ms, size 154KB
*** 2011-09-12 22:56:07.670
Warning: log write time 600ms, size 109KB
*** 2011-09-12 22:56:09.903
Warning: log write time 1790ms, size 190KB
*** 2011-09-12 22:56:11.704
Warning: log write time 1800ms, size 126KB
*** 2011-09-12 22:56:12.854
Warning: log write time 710ms, size 70KB

这些TRACE记录说明LGWR在写出REDO BUFFER到REDO LOGFILE联机日志文件时单次的日志写时间超过了500ms: The above warning messages has been introduced in 10.2.0.4 patchset. The warning message will be generated only if the log write time is more than 500 ms and it will be written to the lgwr trace file. Solution These messages are expected in a 10.2.0.4 database in case the log write is more than 500 ms. This is a warning which means that the write process is not as fast as it intented to be. So, probably you need to check if the disk is slow or not or for any potential OS causes. If everything looks fine at the hardware level or OS level then you can safely ignore these messages. The trace file can easily be deleted or truncated. Also, according to Bug:7559549 , these trace can be disabled by setting event 10468 level 4." 该TRACE信息由10.2.0.4 patchset引入,当LGWR写日志文件单次超过500ms时触发写"Warning: log write time "信息到lgwr trace,如果该信息频繁出现可能意为这潜在的OS IO问题(如果TOP等待事件中还有log file sync、gc buffer busy则值得注意该LGWR IO缓慢问题), 如果在硬件或OS层面都没有问题、且该日志记录出现并不频繁则可以忽略该问题,也可以通过设置10468 EVENT LEVEL 4来禁止写出"Warning: log write time "警告信息。 实际控制这里500ms的是_long_log_write_warning_threshold(threshold for long log write warning messages in ms)隐藏参数,该参数可以在线设置: SQL> alter system set "_long_log_write_warning_threshold"=2000 ; System altered.



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278141

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享: