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. What should they do to remove this bottleneck?

In Oracle Autonomous Database (ADB), compute (OCPU) and I/O resources are bundled together. Scaling the number of OCPUs allocated to the database instance directly and proportionally increases the available I/O throughput, memory, and concurrent session limits. Since the identified bottleneck is storage I/O during inserts, increasing the OCPU count is the designated and most effective method for a user to increase the I/O capacity and thereby improve insert throughput.

A. Removing non-JSON data is irrelevant to the underlying storage I/O capacity. The bottleneck is with physical throughput, not the logical data format being inserted.
B. ADB's architecture is designed to provide consistent performance and mitigate "noisy neighbor" issues. The primary user-controlled method for scaling performance is adjusting OCPUs, not requesting a migration.
D. The DBMSCLOUD.INCREASETHROUGHPUT procedure does not exist. The DBMSCLOUD package is used for operations related to object storage and other cloud services, not for scaling database resources.

1. Oracle Cloud Infrastructure Documentation

Autonomous Database: In the section on managing resources

it states: "When you change the OCPU count

the I/O bandwidth and memory allocated to your database changes in proportion to the OCPU count." This directly supports that increasing OCPUs increases I/O throughput.

Source: Oracle Cloud Infrastructure Documentation

"Scale CPU/IO Resources on an Autonomous Database

" Section: "About Scaling".

2. Oracle Cloud Infrastructure Documentation

Autonomous Database: The documentation on predefined database services shows how different services (HIGH

MEDIUM

LOW) have different concurrency and I/O shares

but the absolute I/O capacity for all services is determined by the database's OCPU count.

Source: Oracle Cloud Infrastructure Documentation

"Predefined Database Service Names for Autonomous Database

" Section: "Concurrency and Parallelism for Predefined Database Services".

3. Oracle Cloud Infrastructure Documentation

DBMSCLOUD Package: The official documentation for the DBMSCLOUD package lists all available subprograms. A procedure named INCREASETHROUGHPUT is not included

confirming it is a fictitious option.

Source: Oracle Database Documentation

"DBMSCLOUD Package Subprograms".