What would you recommend to improve the latency of I/O requests?

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?

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.



Leave a Reply 1

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


L. Zhu

L. Zhu

stripe is the solution

So A is correct