Write complete wait

From DB Optimizer
Jump to: navigation, search

Oracle: write complete wait

Usually happens in tandem with free buffer

Tune by

Increase data block cache

Happens because shadow wants to access blocks that are currently being written to disk by DBWR

also seen it happen when there is a lot of write to sort the waits are on block 2 of the temp tablespace file

Write complete waits.PNG