Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Write Complete Waits

Write complete waits occur when a session tries to modify a block that is currently being written to disk by the database writer process. This happens occasionally, but if it is contributing significantly to overall waits it may indicate inefficiencies in the database writer.

The solution may involve optimizing datafile I/O and database writer configuration. This can be done by spreading datafiles across multiple disks, using multiple database writers, or employing asynchronous or list I/O.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating