AIX: Long "log file sync" Wait Time in 11.2. : Things To Check
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
IBM AIX on POWER Systems (64-bit)
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.
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.
WAITEVENT: "log file sync" Reference Note (Doc ID 34592.1)
First check is to see if "log file sync" waits are high in AWR:
Database Upgraded to 11.2 or a AIX version 6, TL or SP is applied
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