Interested to Buy Any Domain ? << Click Here >> for more details...
When Does DBWR write to the database?
- 6 Answers
- 22732 Views
- I also Faced
- E-Mail Answers
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 |
What is meant by recursive hints ?
What is dictionary cache ?
What do Redo Log Buffers contain?
• What is oracle Architecture?
How many Dispatcher Processes are created?
Which parameter in Storage clause will reduce no. of rows per block?
How will you create multiple rollback segments in a database ?
What is a Control file ?
What is an Oracle Data Block?
What is an Integrity Constrains in Oracle?
What is use of Rollback Segments In Database ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
Oracle General 
