Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - Release Notes

DB File Waits

Wait conditions starting with the phrase DB FILE (for example, db file parallel write, db file scattered read, db file sequential read, and db file single write) all occur when an Oracle session issues an I/O request against an Oracle datafile. The session uses the operating system’s read system call, and waits while the I/O subsystem performs the I/O.

As noted earlier, database-file writes are only performed by the database writer. The db file write waits are never experienced by user sessions. However, user sessions do read data from database files directly, and almost always experience db file read waits.

Unless your entire database is cached in memory, waiting for db file I/O is inevitable. The presence of db file waits does not indicate that anything is wrong within the database. In most healthy databases, db file waits account for about 80-90% of all non-idle wait times.

DB file waits can be reduced by:

  • Optimizing disk I/O, striping datafiles (see Improve Database I/O).
  • Reducing I/O requirements by increasing the size of the buffer cache.
  • Reducing the I/O requirements of SQL statements through SQL tuning (see Isolate and Tune Problem SQL).


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating