Concepts and Architecture Question:

Which parameter specifies the number of DBWn processes?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

The 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.


Previous QuestionNext Question
Can we add a column to view in Oracle?What is the use of archive log file?