Interested to Buy Any Domain ? << Click Here >> for more details...
When Does DBWR write to the database?
- 6 Answers
- 22478 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 |
How many Dispatcher Processes are created?
What is dictionary cache ?
What is SGA?
When will be a segment released?
what is ORACLE MEMORY STRUCTURES
What are the functions of SMON?
What is the maximum number of Lock Processes used?
What is the maximum size of a oracle9i database?
What is meant by free extent ?
Can a Tablespace hold objects from different Schemes in Oracle?
What are functions of PMON?
How will you monitor rollback segment status ?
Oracle General 
