Exam 1z0-070 All QuestionsBrowse all questions from this exam
Go to Exam
Question 17

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?

    Correct Answer: C

    To ensure that DSS and batch workloads maintain high throughput without causing excessive degradation of OLTP performance, the optimal IORM objective should balance both worlds. Setting the IORM objective to 'balanced' balances low disk latency and high throughput, making it suitable for mixed workloads like OLTP and DSS. This setting limits the disk utilization of large I/Os to achieve a balance between latency and throughput, thus ensuring OLTP workloads do not suffer significantly when DSS and batch workloads are running concurrently.

Discussion
IsaacA5Option: C

Correct answer is C balanced - Balances low disk latency and high throughput, which is useful for a mixture of critical OLTP and DSS workloads. This setting limits disk utilization of large I/Os to a lesser extent than low_latency to achieve a balance between latency and throughput. (https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-iorm.html#GUID-3DF7D176-42C3-4A3F-9909-6981CBB91A51)