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 1

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


seenagape

seenagape

I have the same idea. AD