Which statement correctly describes the relationship between the DB_WRITER_PROCESSES …

Which statement correctly describes the relationship between the DB_WRITER_PROCESSES initialization parameter and I/O slaves that are enabled in the Oracle database instance?

Which statement correctly describes the relationship between the DB_WRITER_PROCESSES initialization parameter and I/O slaves that are enabled in the Oracle database instance?

A.
Setting DB_WRITER_PROCESSES to more than one reduces DBWR_IO_SLAVES to one.

B.
Enabling I/O slaves forces the value of the DB_WRITER_PROCESSES parameter to be set to one.

C.
Each DBWR process uses a single I/O slave when DB_WRITER_PROCESSES is set to more than one.

D.
The database performance is directly proportional to the number of I/O slaves when DB_WRITER_PROCESSES is set to more than one.



Leave a Reply 0

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