LGWR Is Generating Trace file with 'Warning Log Write Time 540ms, Size 5444kb' In 10.2.0.4 Database

在升级到10.2.0.4后,用户报告生成了包含警告消息的日志文件,这些警告提示日志写入时间超过500毫秒。此类警告表明写入过程可能较慢,建议检查磁盘速度或潜在的操作系统问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

he customer is reporting trace files being generated with the following message:

Warning: log write time 540ms, size 5444KB
*** 2008-05-14 10:19:02.686
Warning: log write time 1470ms, size 5533KB
*** 2008-05-14 10:19:03.546
Warning: log write time 860ms, size 2230KB
*** 2008-05-14 10:23:04.183
Warning: log write time 2940ms, size 5701KB
*** 2008-05-14 10:23:05.758
Warning: log write time 1580ms, size 4234KB
*** 2008-05-14 10:23:07.559
Warning: log write time 1800ms, size 5701KB

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 in10.2.0.4 database in case the log write is more than 500 ms.

This is a warning which means thatthe 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.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值