ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-070 All Questions

View all questions & answers for the 1z0-070 exam
Go to Exam

Exam 1z0-070 topic 1 question 48 discussion

Actual exam question from Oracle's 1z0-070
Question #: 48
Topic #: 1
[All 1z0-070 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
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.
by IsaacA5 at Feb. 5, 2024, 4:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
IsaacA5
1 year ago
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)
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago