The DBWn background process writes to the datafiles whenever one of the following events occurs:
A user’s Server Process has searched too long for a free buffer when reading a buffer into the Buffer Cache.
The number of modified and committed, but unwritten, buffers in the Database Buffer
Cache is too large.
At a database Checkpoint event. See Chapters 10 and 11 for information on checkpoints.
The instance is shut down using any method other than a shutdown abort.
A tablespace is placed into backup mode.
A tablespace is taken offline to make it unavailable or changed to READ ONLY.
A segment is dropped.