Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
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.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can we add a column to view in Oracle? | What is the use of archive log file? |