Interested to Buy Any Domain ? << Click Here >> for more details...
When Does DBWR write to the database?
- 6 Answers
- 22940 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 the maximum number of Lock Processes used?
When does LGWR write to the database?
What is hit ratio ?
How can we plan storage for very large tables ?
What are the uses of Oracle Rollback Segment?
When Does DBWR write to the database?
How the space utilisation takes place within rollback segments?
Teradata: How can we know the indexed column in a table?
What is an Oracle Rollback Segment?
How will you monitor the space allocation ?
What is a Multi-threaded Server Configuration?
What is the function of checkpoint(CKPT)?
Oracle General 
