You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = off
alter iormplan active
There are no database or category plans defined.
You are suffering I/O performance problems at certain times, which vary by day and week.
DSS and batch workloads perform well, but your OLTP workloads suffer poor response times when running at
the same time as these other workloads.
You must ensure that DSS and batch workloads retain relatively high throughput without causing excessive
degradation of OLTP performance.
Which statement would you issue to all Exadata Storage Servers to achieve this?
A.
alter iormplan objective = low_latency
B.
alter iormplan objective = high_throughput
C.
alter iormplan objective = balanced
D.
alter iormplan objective = auto
Explanation:
When the objective option is set to basic, the database resource plan maximum utilization limits are not enforced. For stricter plan conformance, and enforcement of maximum utilization limits, the objective option must be set to something other than basic. The supported IORM objectives are auto, low_latency, balanced,
and high_throughput.
The objective may also be changed to low_latency in which case the latency for critical I/Os is very good but there is a significant degradation in scan throughput when both workloads are running concurrently.
Incorrect Answers:
B: The objective can be changed to high_throughput which will increase the scan throughput at the cost of critical I/O latency.
C, D: The recommended objective option is auto which allows IORM to continuously monitor the workloads, and select the best mode based on the active workloads currently on the cells. The objective values of auto and balanced have the same behavior.