OCI Database Services Professional study materials
OCI Database Services Professional study resources

OCI Database Services Professional case studies

OCI Database Services Professional · Put your knowledge to work in context.

The Oracle Cloud Infrastructure Database Services Professional credential is identified by exam code 1Z0-1093, which appears in the Oracle University exam page URL slug. Oracle University is Oracle's own training and certification organization, and its site describes certification as a way to "Earn a recognized credential that can help validate in‑demand skills and support your career growth." This page is an independent study resource and is not affiliated with, endorsed by, or sponsored by Oracle. The OCI Database Services Professional case studies are 5 cases and about 3,887 words.

1

Month-End Batch Slowdown on Autonomous Database Serverless

A retail customer runs its order-management suite on an Autonomous Database Serverless instance in the Frankfurt region, provisioned with 8 ECPUs and auto scaling enabled. Every month-end the finance team runs a single-threaded PL/SQL aggregation job that historically finished in 25 minutes.

813 words, about 4 min
2

Apply Lag and a Regional RTO Gap on Exadata Database Service

A logistics company runs a quarter-rack X9M Exadata Database Service on Dedicated Infrastructure in the London region. The production VM cluster has two database nodes running Oracle RAC 19c, and redo ships to a single-node standby VM cluster in the same region but a different availability domain.

770 words, about 4 min
3

Table Recovery, Immutable Backups and BYOL on Base Database Service

A financial-services firm runs a two-node RAC VM DB system on OCI Base Database Service, Oracle 19c, BYOL, 4 OCPUs per node and 1.5 TB of storage. Automatic backups are enabled with 30-day retention, and a Data Guard standby sits in a second region.

783 words, about 4 min
4

Cutting Over an 11g Database With a Ten-Minute Window

A hospital group must move a 6 TB patient-records database from an on-premises Oracle 11.2.0.4 single instance on Linux to OCI within one quarter. The source runs on end-of-life hardware, and the business wants a fully managed target with no OS access, automatic patching and a built-in standby.

754 words, about 4 min
5

Customer-Managed TDE Keys, Rotation and Audit Retention

A European insurer runs six production databases on OCI Base Database Service, each with a Data Guard standby in a second region. All are encrypted with TDE using customer-managed keys in an OCI Vault configured for HSM protection.

767 words, about 4 min