adspace


When Does DBWR write to the database?

Answer Posted / vinodh ramaswamy

DBWn background process writes to the datafiles
whenever one of the following events occurs:


1.when ckpt triggers dirty buffer moved from db_buffer_cache to datafile.
2.when 1/3rd of the db_buffer cache gets filled.

3.The instance is shut down using any method other than a
shutdown abort.

Is This Answer Correct ?    7 Yes 4 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