LOG FILE SYNC WAITS SPIKES DURING RMAN ARCHIVELOG BACKUPS
(Doc ID 1229104.1)
Last updated on DECEMBER 06, 2019
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);
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document