direct path write

The direct path write wait event has three parameters: file#, first block#, and block count. In Oracle Database 10g, this wait event falls under the User I/O wait class. Keep the following key thoughts in mind when dealing with the direct path write wait event.

Image These are waits that are associated with direct write operations that write data from users’ PGAs to data files or temporary tablespaces. Oracle direct I/O is not the same as Unix operating system’s direct I/O. Oracle direct I/O bypasses the SGA, while the Unix operating system direct I/O bypasses the file system cache.

Direct writes may be performed in synchronous or ...

Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.