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 220.127.116.11 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!