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.
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
