All wait events related to database writer push-to-disk issues start with db file. As with other IO events, just before and after the IO call, a gettimeofday call is made, and the difference is what we see through Oracle's wait interface. Here are the two common database writer push-to-disk wait events:

* db file parallel write: By the far the most common database writer wait event, a parallel write is simply a multiblock write, like most of the calls shown in Figure 6-24. This is the result of the database writer feeding off the write list and writing a batch of dirty blocks to disk. I like to see the wait time below 5 ms, but every organization has its own budget and service level requirements. A write less than 5 ms indicates write caching is working well. The write calls in Figure 6-24 range from around 1.5 ms to nearly 40 ms!

* db file single write: This should never be the top wait event. This can possibly occur at the end of a checkpoint when all the database file header blocks must be written. These are done one at a time by multiple single-block writes.