DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - db file single write

db file single write

This event is used to wait for the writing of the file headers. Normally single writes are the writes happening on the header blocks and parallel writes are the writes in the non header blocks. Wait Time:

The wait time is the actual time it takes to do the I/O.

Parameter

Description

file#

File Number

block#

Starting Block Number

blocks

This is the number of blocks that the session is trying to write in file# starting at block#