Which parameter specifies the number of DBWn processes?
Submitted by: AdministratorThe initialization parameter DB_WRITER_PROCESSES specifies the number of DBWn processes. The maximum number of DBWn processes is 20. If it is not specified by the user during startup, Oracle determines how to set DB_BLOCK_PROCESSES based on the number of CPUs and processor groups.
Submitted by: Administrator
Submitted by: Administrator
Read Online Concepts and Architecture Job Interview Questions And Answers
Top Concepts and Architecture Questions
☺ | What is a Segment in Oracle? |
☺ | Explain can a Tablespace hold objects from different Schemes? |
☺ | Explain what is the function of Redo Log? |
☺ | What is Oracle Identity Analytics? |
☺ | Explain what is Public Database Link? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |