Oracle · Software · YoctoIT tech page

Autonomous

The database that administers itself in OCI: automatic patching, tuning, scaling and security — the DBA looks higher.

FOCUS · REAL AUTOMATIONTruly self-driving: maintenance disappears, governance remains
YoctoIT material for clients and partners · Oracle, Exadata, GoldenGate and the other products mentioned are trademarks of Oracle Corporation e/o sue affiliate.
01 · What it is

Autonomous Database, made clear.

Autonomous is Oracle Database on Exadata OCI with automation at its peak: it patches itself (online), tunes itself (indexes and plans), scales itself, protects itself. Serverless or dedicated, transactional or warehouse: the basic operations evaporate — architecture, data and costs remain.

Zero patch
updates apply online, on their own, without windows
Auto-tuning
automatic indexes and plans corrected by machine learning
Auto-scale
CPU up and down with the load: you pay for consumption, not the peak
Autonomous Database
OFFICIAL ORACLE BRANDING · AUTONOMOUS
CONSOLE OCI REALE · MONITORAGGIO AUTONOMOUS · FONTE: ORACLE BLOG
REAL OCI CONSOLE · AUTONOMOUS MONITORING · SOURCE: ORACLE BLOG
02 · How to use it well

The things that make the difference.

What remains for those who remain

Applications and datathe value, always yours
ATP · transactional
ADW · warehouse
AJD · JSON
the variant for the workload
Governance: costs, access, modelthe noble work that remains
Exadata in OCI (or C@C)the iron, invisible
The infrastructure evaporates, the data remains

The right workload

Autonomous shines on new developments and datamarts: demanding legacy apps must be assessed first.

Migration with method

Data Pump, GoldenGate and regression tests: even the self-driving car wants a pilot to get in.

Governed elastic costs

Auto-scaling yes, but with limits and monitoring: elasticity without surprises.

Security by default

Encryption, immediate patches and Data Safe: the baseline that costs sweat on-prem.

03 · In depth

Self-driving: what it really automates

Autonomous Database automates provisioning, patching (online, quarterly), tuning (automatic indexes, managed plans), scaling (online OCPUs and storage, 3x auto-scaling) and security (always-on encryption, immediate security patches). Workload types (transactional ATP, analytic ADW, JSON AJD) pre-configure the engine; Data Safe assesses the posture; clones (full/metadata/refreshable) make dev and test a click.

  • Auto-indexing — indexes created/validated/retired by the engine: continuous tuning
  • Auto-scaling — up to 3x OCPUs when needed: the peak absorbed, the bill comes back down
  • Patch online — quarterly without downtime: the maintenance window disappears
  • Cloni refreshable — the test synced from prod with a refresh: real data, zero risk
  • Workload type — ATP/ADW/AJD: the engine already tuned for your workload
  • Data Safe — assessment, masking and audit included: the posture measured
04 · Numbers and lifecycle

The numbers that matter.

99,95%
the standard SLA (99.995% with Autonomous Data Guard)
3x
auto-scaling on the cores: elasticity without tickets
0
manual patches: the DBA moves to value
min
provisioning: the database ready in minutes
Autonomy moves the work, it doesn't remove it: data models, security and integration remain a craft — ours.
05 · Use cases

Where it really pays off.

New applications

The database without a DBA to start fast.

Datamarts and sandboxes

Analytics provisioned in minutes, switched off when done.

Modernization

The ERP going up to the cloud leaving the maintenance on the ground.

Less administration doesn't mean less governance: we watch over what the automation doesn't see.