| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
|
|
Modifiable |
No |
|
Range of values |
1 to 100 |
|
Basic |
No |
DB_WRITER_PROCESSES specifies the initial number of Database Writer Processes for an instance. This parameter is useful for systems that modify data heavily.
There can be 1 to 100 Database Writer Processes. The names of the first 36 Database Writer Processes are DBW0-DBW9 and DBWa-DBWz. The names of the 37th through 100th Database Writer Processes are BW36-BW99.
See Also:
Background Processes for additional information about the Database Writer Process
Oracle Database Concepts for information on when the Database Writer Process writes dirty buffers to disk