When Does DBWR write to the database?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / syed alamdar ali
when log switch occurs
shut down
every 3 sec if set
when treshold is full
least recently used
Is This Answer Correct ? | 26 Yes | 6 No |
Answer / 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 |
Answer / samal
1.When checkpoint occur.
2.Commit statement occur.
3.When ever you are going to shutdown instance.
4.When ever you are going to take tablespace begin backup.
Is This Answer Correct ? | 3 Yes | 13 No |
Answer / ravi dutta
this writes all the commited data from the buffer cache to
the data file.
Is This Answer Correct ? | 13 Yes | 24 No |
How the log writer writes the data into database
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
When will be a segment released?
What is an Oracle Data Block?
What is SGA?
Why query fails sometimes ?
How will you force database to use particular rollback segment?
What is meant by recursive hints ?
What is Server Process?
What are the consideration at tehe migration of Oracle 9i to 10G.
Can a Tablespace hold objects from different Schemes in Oracle?
When Does DBWR write to the database?