AIX: Long "log file sync" Wait Time in 11.2. : Things To Check
(Doc ID 1318709.1)
Last updated on MARCH 03, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
IBM AIX on POWER Systems (64-bit)
Symptoms
This is a general guide based on resolved issues where Log File Sync problems were found to be related to AIX configurations on AIX 6.1 (+ later) and Oracle 11.2.0.x.
NOTE: Some of these concepts and scenarios may apply and be helpful where the database is later than 11.2.
In these examples, wait times for "log file parallel write" were all very good.
For "log file sync" issues you should always review the following notes as a first step.
Troubleshooting: "Log File Sync" Waits (Doc ID 1376916.1)
WAITEVENT: "log file sync" Reference Note (Doc ID 34592.1)
WAITEVENT: "log file sync" Reference Note (Doc ID 34592.1)
First check is to see if "log file sync" waits are high in AWR:
Changes
Database Upgraded to 11.2 or a AIX version 6, TL or SP is applied
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 |
| Changes |
| Cause |
| Solution |
| References |