Which two statements are correct about the DB_WRITER_PROCESSES initialization parameter?

Which two statements are correct about the DB_WRITER_PROCESSES initialization parameter?
(Choose two.)

Which two statements are correct about the DB_WRITER_PROCESSES initialization parameter?
(Choose two.)

A.
The default value for DB_WRITER_PROCESSES is (CPU_COUNT+7)/8.

B.
You set DB_WRITER_PROCESSES to greater than one to simulate asynchronous
input/output (I/O).

C.
You cannot set DB_WRITER_PROCESSES to greater than one if asynchronous I/O is
enabled for the Oracle server.

D.
You cannot set DB_WRITER_PROCESSES to greater than one if the DBWR_IO_SLAVES
initialization parameter is set to greater than zero.

E.
You must set an appropriate value for the LOG_PARALLELISM initialization parameter before
modifying the default value for DB_WRITER_PROCESSES.



Leave a Reply 0

Your email address will not be published. Required fields are marked *