LOG FILE SYNC WAITS SPIKES DURING RMAN ARCHIVELOG BACKUPS
Last updated on OCTOBER 26, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
A decrease in transaction throughput was noticed at the same time as RMAN was backing up archivelogs.
Ashdumps were taken at the time of the slowdown (see <Note 555303.1>) and the following query showed a correlation between time 'log file sync' wait and 'CF-enqueue' spikes:
group by sample_time,event,time_waited
order by sum(time_waited);
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