Oracle System Architecture Question:
Explain when Does DBWR write to the database?
Answer:
DBWn writes when:
1)checkpoint occurs
2)dirty buffers reach threshold
3)there are no free buffers
4)timeout occurs
5)RAC ping request is made
6)when any tablespace is taken offline,read only,drop or truncated & when begin backup
1)checkpoint occurs
2)dirty buffers reach threshold
3)there are no free buffers
4)timeout occurs
5)RAC ping request is made
6)when any tablespace is taken offline,read only,drop or truncated & when begin backup
| Previous Question | Next Question |
| What is the function of checkpoint (CKPT)? | What is SGA in Oracle System Architecture? |