Explain when Does DBWR write to the database?
Submitted by: AdministratorDBWn 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online Oracle System Architecture Job Interview Questions And Answers
Top Oracle System Architecture Questions
| ☺ | Explain what are functions of PMON? |
| ☺ | What is the function of Lock (LCKn) Process in System Architecture? |
| ☺ | Tell me what are the functions of SMON? |
| ☺ | Explain what are the different Oracle Kernel Layers? |
| ☺ | Explain what do Redo Log Buffers contain? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
