DBWn Processes

Which parameter specifies the number of DBWn processes?

Questions by megha90

Showing Answers 1 - 18 of 18 Answers

hmounir

  • Jul 5th, 2010
 

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.

abhishek singh

  • Aug 1st, 2011
 

v$database

  Was this answer useful?  Yes

Harshad Khuspe

  • Feb 27th, 2015
 

DBWR is the optimal name for Database Writer. Where as n is number which are for 0-9 and a-j. DBWn process writes data from database buffer chache to the disk in the case of block becomes dirty and and after check point occurs. DBWn process depends upon the total CPU used for the process. Which is total number of CPU/8. For example if total number of CPUs are 4 then 4/8 = 2 then total 2 DBWn process will allocate.

  Was this answer useful?  Yes

srinivasarao

  • Mar 22nd, 2015
 

DB_WRITER_PROCESS=""

  Was this answer useful?  Yes

mosinpatel

  • Jan 18th, 2018
 

SQL> show parameter db_writer_processes
NAME TYPE VALUE
------------------------------------ ----------- -------
db_writer_processes integer 1

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions