High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

The correct answer is A. Enable Write-Back Flash Cache due to heavy DBWR usage. D. Tune the application to reduce I/O requests. E. Leverage IORM to give priority to critical workloads. B cannot be the answer because, Write-Back Flash Cache is only for DBWR. LGWR uses Flash Log and not Flash Cache. So for heavy LGWR usage, we need to verify that Flash Log exists and flashLog=on for the database in the IORM dbPlan.

Performance Optimization

Question

Options

AEnable Write-Back Flash Cache due to heavy DBWR usage.
BEnable Write-Back Flash Cache due to heavy LGWR usage.
CSwap hard disks to High Capacity disks.
DTune the application to reduce I/O requests.
ELeverage IORM to give priority to critical workloads.

How the community answered

(39 responses)

A
72% (28)
B
18% (7)
C
10% (4)

Explanation

B cannot be the answer because, Write-Back Flash Cache is only for DBWR. LGWR uses Flash Log and not Flash Cache. So for heavy LGWR usage, we need to verify that Flash Log exists and flashLog=on for the database in the IORM dbPlan.

Topics

#IOPS optimization#Write-Back Flash Cache#IORM#I/O tuning

Community Discussion

No community discussion yet for this question.

Full 1Z0-485 Practice