Oracle
1Z0-054 · Question #113
1Z0-054 Question #113: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #113. The question stem and answer options stay visible for context.
Question
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?
Options
- AStripe data across multiple disks.
- BIncrease the size of buffer cache.
- CDecrease the value of the DBWR_IO_SLAVES parameter.
- DIncrease the value of the DB_WRITER_PROCESSES parameter.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.