Warning: log write time 560ms, size 3KB

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:Warning: log write time 560ms, size 3KB


*** 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]
The problem surfaced after upgrading to

The above warning messages has been introduced in 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 .

These messages are very much expected in 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.

the error may be suppressed by setting Event 10468 level 4.
alter system set events ’10468 trace name context level 4′;
ALTER SYSTEM SET EVENTS ’10468 trace name context off’;

此条目发表在 Oracle 分类目录。将固定链接加入收藏夹。