LGWR Spinning and Waiting for "log file parallel write" When Redologs are on ASM (Doc ID 1998116.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

1] LGWR spinning and waiting for "log file parallel write" when redologs are on ASM. Same test having redologs on filesystem does not reproduce such behavior.

2] LGWR uses over 90% CPU on active wait while there is no real wait on ASM side.

3] LGWR trace file shows high elapsed time 

Warning: log write elapsed time 2017ms, size 1959KB
Warning: log write elapsed time 4729126ms, size 34865K
Warning: log write elapsed time 170569ms, size 14084KB
Warning: log write elapsed time 500ms, size 768KB
Warning: log write elapsed time 1095ms, size 2KB
Warning: log write elapsed time 577ms, size 2KB
Warning: log write elapsed time 6050ms, size 823KB
Warning: log write elapsed time 100428ms, size 9863KB

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms