Interested to Buy Any Domain ? << Click Here >> for more details...
When Does DBWR write to the database?
- 6 Answers
- 22415 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 |
Name the ORACLE Background Process?
What is an Oracle SYSTEM tablespace and when is it Created?
What are the two types of Server Configurations?
1.Explain the three levels with the help og a diagram.
What are the consideration at tehe migration of Oracle 9i to 10G.
What is an Oracle Data Dictionary?
Teradata: How can we know the indexed column in a table?
What are the components of SGA?
What is an Oracle Data Block?
How will you monitor rollback segment status ?
What does LGWR do?
How to implement the multiple control files for an existing database ?
Oracle General 
