# Oracle Autonomous AI Database

> Self-tuning managed warehouse running on Oracle Exadata

Oracle Autonomous AI Database is a fully managed analytical database on Exadata infrastructure that automates provisioning, tuning, patching, and backup, with an Always Free tier and independently elastic compute and storage.

Website: https://www.oracle.com/autonomous-database/

## Use it when

- The estate is already Oracle; PL/SQL, existing ETL, and DBA-shaped skills carry over without a migration project.
- You want the operational surface gone: provisioning, tuning, patching, backup, and recovery are the service's job, with auto-indexing standing in for hand tuning.
- Deployment flexibility matters: shared serverless, dedicated Exadata, Cloud@Customer in your data center, and Oracle Database@ inside Azure, Google Cloud, and AWS.
- Two Always Free instances make indefinite evaluation genuinely free.

## Think twice when

- You are not an Oracle shop; greenfield analytics teams usually land on Snowflake, BigQuery, or a lakehouse first, and Oracle SQL plus PL/SQL is its own world.
- Cost transparency matters; ECPU pricing is straightforward, but the surrounding platform decisions (OCI, support, licensing culture) are part of what you are buying.
- Open table formats should be the primary store; it reads Iceberg, Parquet, and Delta but stores proprietary.

## How it runs

Fully managed on Exadata: shared-disk architecture where ECPUs scale independently of storage, per-second billing, auto-scaling to three times baseline, and scale-to-zero when idle on serverless. Predefined HIGH/MEDIUM/LOW services shape concurrency. GoldenGate and Kafka connectors feed it; Flashback provides 60-day time travel by default.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Commercial |
| Deployment | Managed, Serverless |
| Operational complexity | Low |
| Pricing | Free, Subscription |
| Documentation | https://docs.oracle.com/en/cloud/paas/autonomous-database/ |

### Data Warehouses

| Attribute | Value |
| --- | --- |
| Where it runs | OCI, plus Azure, Google Cloud and AWS via Oracle Database@; Cloud@Customer on-premises |
| Compute and storage | Shared-disk Exadata: ECPUs scale apart from storage, auto scaling to 3x |
| Storage format | Proprietary; reads Iceberg, Parquet and Delta in object storage |
| SQL dialect | Oracle SQL and PL/SQL |
| Streaming ingest | Via connector: GoldenGate or Kafka; scheduled pipelines from object storage |
| Concurrent users | Predefined services HIGH/MEDIUM/LOW/TP: MEDIUM admits 1.25x base ECPUs, 3.75x with auto scaling |
| Acceleration | Automatic indexing, materialized views and partitioning; Exadata smart scan and storage indexes; result cache |
| Billing unit | ECPU-hour, billed per second with a one-minute minimum; storage per TB-month |
| Time travel | Flashback Query and Flashback Time Travel, 60-day archive by default, configurable |
| Access control | IAM and database roles; Database Vault, VPD, Label Security, data redaction, unified auditing with Data Safe |

## Capabilities

- [Data Warehouses](https://matca.io/capabilities/data-warehouse)

---

Source: https://matca.io/oracle-autonomous-ai-database
Last updated: 2026-08-31T11:40:48.669Z