LGWR Spinning and Waiting for "log file parallel write" When Redologs are on ASM
(Doc ID 1998116.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |