'Log File Sync' problem on a Sun Server: Discussion of a Potential Source for LOGFILE SYNC Performance Problems plus references
(Doc ID 1205673.1)
Last updated on MAY 12, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 220.127.116.11.0 [Release 10.2 to 11.2]
Oracle Database - Standard Edition - Version 10.2.0.1 to 18.104.22.168.0 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Log File Sync
For more excellent information regarding high resolutions timeouts please see Steve Sistare's Oracle Blog regarding High Resolution Timeouts
- You have recently upgraded your database on a Sun Server and now you are finding very poor performance, including notable Log File Sync (LFS) problems as reported in the AWR reports
- The Logfile Syncs are seen on the same server that did not have problems with Log File Syncs as the top of the Top 5 Wait Event
- IO performance appears to be within normal ranges
- Background and Foreground Waits also appear to confirm the Logfile Sync performance as a serious performance problem
- Customer has a 10.2.0.4 database and an 22.214.171.124 database
- The same import is run on each database. However the time to complete the import varies greatly.
- 10.2.0.4 => 55 minutes
- 126.96.36.199 => 5 hours
- Furthermore: the problem was seen on the SAME server where the 10.2x performance was normal
- You have recently changed the database version on the Sun Server to a newer database version such as 11gR2
- No other changes are known
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