Oracle System Architecture Interview Question:

Explain when Does DBWR write to the database?

Submitted by: Administrator

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
Submitted by: Administrator