adspace


When Does DBWR write to the database?

Answer Posted / milentechie

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.

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category