You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency
alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and
sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads.
Which statements would you issue to all Exadata Storage Servers to achieve this?
A.
alter iormplan objective=high_throughput
B.
alter iormplan objective=balanced
C.
alter iormplan objective=low_latency
D.
alter iormplan objective= auto
E.
alter iormplan objective= ‘ ’