You are working as a DBA on an online transaction processing (OLTP) system. This OLTP systems runs on a machine with a single CPU, on which applications primarily perform small random I/Os where each foreground process reads a data block into the buffer cache for updates and the changed blocks are written in batches by the DBWR process. You noticed the increase in I/O requests queued up against a disk, and an increase in the wait time in queue.
What would you recommend to improve the latency of I/O requests?
A.
Stripe data across multiple disks.
B.
Increase the size of buffer cache.
C.
Decrease the value of the DBWR_IO_SLAVES parameter.
D.
Increase the value of the DB_WRITER_PROCESSES parameter.