Slow Running User Process And Top Database Wait Event Is 'log file switch (private strand flush incomplete)'
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms