DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - log file single write

log file single write

Waiting for the write to this logfile to complete. This event is used while updating the header of the logfile. It is signaled when adding a log file member and when incrementing sequence numbers. Wait Time:

Time it takes for the physical I/O (write) to complete

Parameter

Description

log#

This is the number of the group/log to which the session is currently writing

block#

Block Number

blocks

The number of blocks to write