Concepts and Architecture Question:
Which parameter specifies the number of DBWn processes?
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 Question | Next Question |
| Can we add a column to view in Oracle? | What is the use of archive log file? |