Question:
What is the maximum number of database writer processes allowed in an Oracle instance?
Answer:
The maximum is ten. Every Oracle instance begins with only one database writer process, DBW0. Additional writer processes may be started by setting the initialization parameter DB_WRITER_PROCESSES (DBW1 through DBW9). Source: CoolInterview.com
i think its 20 (DBW0 THROUGH DBW9, AND DBWa THROUGH DBWJ) IN ORACLE 11G Source: CoolInterview.com
Answered by: Nelson Xavier | Date: 10/23/2009
| Contact Nelson Xavier
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|