Which situations does the Database Writer process (DBWn) write to data files?

In which situations does the Database Writer process (DBWn) write to data files?
A. when the RMANI recovery process starts
B. when a user process commits a transaction
C. when a tablespace is made read-only or taken offline
D. when PMON cleans up dirty buffers in the database buffer cache
E. when clean buffers for reading new blocks into the database buffer cache are not found easily

Download Printable PDF. VALID exam to help you PASS.

2 thoughts on “Which situations does the Database Writer process (DBWn) write to data files?

  1. the ans should be CE
    B is wrong, it is rather the log writer that writes to redo log file whenever is a commit or roll back.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.