DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - db file parallel read

db file parallel read

This happens during recovery. It can also happen during buffer prefetching, as an optimization (rather than performing multiple single-block reads). Database blocks that need to be changed as part of recovery are read in parallel from the database. Wait Time:

Wait until all of the I/Os are completed.

Parameter

Description

files

This indicates the number of files to which the session is reading.

blocks

This indicates the total number of blocks to be read.

requests

This indicates the total number of I/O requests, which will be the same as blocks.