Slow Running User Process And Top Database Wait Event Is 'log file switch (private strand flush incomplete)'
(Doc ID 983473.1)
Last updated on MARCH 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2016***
Checked for relevance on 31-Oct-2011
A user process is running very slow and the top database wait event is always 'log file switch (private strand flush incomplete)'.
AWR Report shows the following Top 5 Timed Events.
- log file switch (private strand flush incomplete)
- buffer busy waits
- log file sync
- db file sequential read
- log file switch (checkpoint incomplete)
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|