sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle警告 Warning:log write time 560ms, size 3KB解决办法

时间:2016-06-30 09:08   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净 运维DBA在巡检Oracle数据库时发现alert日志中出现大量警告日志:Warning:log write time 560ms, size 3KB

1、Oracle警告日志

xunzhi_lgwr_27974.trc文件中
*** 2011-09-14 09:30:04.947
Warning: log write time 500ms, size 0KB
*** 2011-09-14 09:33:41.058
Warning: log write time 560ms, size 3KB
*** 2011-09-14 09:48:55.597
Warning: log write time 820ms, size 0KB
*** 2011-09-14 10:00:50.477
Warning: log write time 870ms, size 0KB

2、Metalink描述[ID 601316.1]分析Warning: log write time 820ms, size 0KB

Changes
The problem surfaced after upgrading to 10.2.0.4.

Cause
The above warning messages has been introduced in 10.2.0.4 patchset. This 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 very much expected in 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.

3、Oralce警告Warning: log write time 820ms, size 0KB解决方案

the error may be suppressed by setting Event 10468 level 4.
alter system set events ’10468 trace name context level 4′;
取消该trace命令为:
ALTER SYSTEM SET EVENTS ’10468 trace name context off’;


--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle警告 Warning:log write time 560ms, size 3KB解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/642.html

Oracle研究中心

关键词:

Oracle警告

Warning:log write time 560ms

size 3KB解决办法