What is the maximum number of database writer processes allowed in an Oracle Instance?
1. 1
2. 10
3. 256
4. Set by underlying OS.
Answer 2: By default, every Oracle instance has one database writer process started DBW0. You can start additional processes by changing the value of the initialization parameter DB_WRITER_PROCESSES to a value of 10. This will give you DBW1 - DBW9 additionally.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment