My Oracle Support Banner

AIX: Long "log file sync" Wait Time in 11.2. : Things To Check (Doc ID 1318709.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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. 

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)

 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


To view full details, 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 a vibrant support community of peers and Oracle experts.