DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - log file sync

log file sync

When a user session commits, the session's redo information needs to be flushed to the redo logfile. The user session will post the LGWR to write the log buffer to the redo log file. When the LGWR has finished writing, it will post the user session. Wait Time:

The wait time includes the writing of the log buffer and the post.

Parameter

Description

buffer#

The number of the physical buffer in the redo log buffer that needs to be synchronized