LGWR Posting Slow Write Times, Low IO Waits

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

/orasys/admin/bdump/ecs_lgwr_3492.trc:"
LGWR trace files;

ecs_lgwr_3492.trc

LGWR trace is filled up with the messages like:

*** 2011-05-29 08:14:52.315
Warning: log write time 650ms, size 36KB
*** 2011-05-29 08:14:55.507
Warning: log write time 1110ms, size 8KB
*** 2011-05-29 08:14:57.783
Warning: log write time 2270ms, size 39KB
*** 2011-05-29 08:14:58.810
Warning: log write time 1030ms, size 67KB
*** 2011-05-29 08:15:02.055
Warning: log write time 1730ms, size 79KB
*** 2011-05-29 08:15:04.723
Warning: log write time 2670ms, size 88KB
*** 2011-05-29 08:15:07.057
Warning: log write time 2340ms, size 63KB
*** 2011-05-29 08:15:08.414
Warning: log write time 1350ms, size 53KB
*** 2011-05-29 08:15:10.902
Warning: log write time 2490ms, size 65KB
*** 2011-05-29 08:15:13.763
Warning: log write time 2860ms, size 99KB
*** 2011-05-29 08:15:16.373
Warning: log write time 2590ms, size 103KB
*** 2011-05-29 08:15:17.908
Warning: log write time 1540ms, size 169KB

 Solution:

This message shows we have a very slow Log writing . We are seeing this is manifested in log file sync waits.
Please involve your storage admin to verify slow performance due to redo writing on the disk where redo log files are present.

Refer:
LGWR Is Generating Trace file with "Warning: Log Write Time 540ms, Size 5444kb" In 10.2.0.4 Database (Doc ID 601316.1)
High Log File Sync Wait Events, LGWR Posting Slow Write Times, Low IO Waits (Doc ID 1278149.1)


    

Get Oracle Certifications for all Exams
Free Online Exams.com