AIX: Long "log file sync" Wait Time in 11.2. : Things To Check

(Doc ID 1318709.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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)

 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

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