A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment…

Addressing a storage I/O bottleneck for insert throughput in Autonomous Database involves resource

adjustments:

Correct Answer (C): “Increase the number of OCPUs allocated to the database” boosts processing

power, which directly improves I/O performance. In Autonomous Database, OCPUs handle both

compute and I/O operations; more OCPUs increase the I/O bandwidth, reducing the bottleneck for

insert-heavy workloads.

Incorrect Options:

A: Removing non-JSON data may optimize storage use but doesn’t directly address I/O throughput

for inserts.

B: “Noisy neighbors” is a shared infrastructure concern, but migration isn’t a standard solution for I/O

bottlenecks and requires Oracle intervention, not user control.

D: There is no DBMS_CLOUD.INCREASE_THROUGHPUT procedure; this is a fabricated option.

Scaling OCPUs is the most effective user-controlled solution.

Reference: Scaling Autonomous Database