Oracle Database 12c: Multitenancy Essentials — Question 28

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?

Answer options

• A. alter iormplan objective = low_latency
• B. alter iormplan objective = high_throughput
• C. alter iormplan objective = balanced
• D. alter iormplan objective = auto

Correct answer: A

Explanation

The correct answer is A, as setting the IORM plan objective to low_latency prioritizes OLTP workloads, ensuring they perform better during peak times. Option B, high_throughput, would favor DSS and batch jobs, worsening OLTP performance. Option C, balanced, attempts to strike a middle ground but may not adequately protect OLTP workloads. Option D, auto, allows the system to decide, which may not address the specific performance issues faced.