When Does DBWR write to the database ?

DBWR  writes  when  more  data  needs  to  be read into the SGA and too few database  buffers  are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs.
  • Interview Candidate
  • 4
  • 17349

Showing Answers 1 - 4 of 4 Answers

sweety

  • Apr 26th, 2006
 

DBWn writes when:

1)checkpoint occurs

2)dirty buffers reach threshold

3)there are no free buffers

4)timeout occurs

5)RAC ping request is made

6)when any tablespace is taken offline,read only,drop or truncated & when begin backup

subhash.terdale

  • Oct 1st, 2008
 

DBWR writes
* when checkpoint occures
* when dirty buffers reach threshold
* when RAC ping requested
* when free buffers are not available
* when tablespace taken offline,droped

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions