DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - log file switch (private strand flush incomplete)

log file switch (private strand flush incomplete)

User sessions trying to generate redo, wait on this event when LGWR waits for DBWR to complete flushing redo from IMU buffers into the log buffer. When DBWR is complete LGWR can then finish writing the current log, and then switch log files. Wait Time:

1 second

Parameters:

None