Oracle Cloud Infrastructure Documentation

Overview of Autonomous Database

Oracle Cloud Infrastructure's Autonomous Database is a fully managed, preconfigured database environment with two workload types available, Autonomous Transaction Processing and Autonomous Data Warehouse. You do not need to configure or manage any hardware, or install any software. After provisioning, you can scale the number of CPU cores or the storage capacity of the database at any time without impacting availability or performance. Autonomous Database handles creating the database, as well as the following maintenance tasks:

  • Backing up the database
  • Patching the database
  • Upgrading the database
  • Tuning the database

Always Free Availability

Autonomous Database can be used for free as part of Oracle Cloud Infrastructure's suite of Always Free resources. Users of both paid and free Oracle Cloud Infrastructure accounts have access to two Always Free instances of Autonomous Database. Always Free Autonomous Databases have a fixed 8 GB of memory, 20 GB of storage, 1 OCPU, and can be configured for either Autonomous Transaction Processing or Autonomous Data Warehouse workloads.

For an introduction to the Free Tier, see Oracle Cloud Infrastructure's Free Tier. For details of the Always Free Autonomous Database, see Overview of the Always Free Autonomous Database. To provision an Always Free Autonomous Database, see To create an Always Free Autonomous Database.

For information on regional availability of Always Free Autonomous Database, see the "Always Free Cloud Services" section of Data Regions for Platform and Infrastructure Services.

Available Workload Types

Autonomous Database offers two workload types:

  • The Autonomous Transaction Processing workload type configures the database for a transactional workload, with a bias towards high volumes of random data access.

    For a complete product overview of Autonomous Transaction Processing, see Autonomous Transaction Processing. For Autonomous Transaction Processing tutorials, see Quick Start tutorials.

  • The Autonomous Data Warehouse workload type configures the database for a decision support or data warehouse workload, with a bias towards large data scanning operations.

    For a complete product overview of Autonomous Data Warehouse, see Autonomous Data Warehouse. For Autonomous Data Warehouse tutorials, see Quick Start tutorials.

Infrastructure Options

Autonomous Databases have the following Exadata infrastructure options:

  • Dedicated Exadata Infrastructure:  With this option, you have exclusive use of the Exadata hardware. Dedicated Exadata infrastructure offers multitenant database architecture, allowing you to create and manage multiple Autonomous Databases within a single database system. For an overview, see Overview of Autonomous Database on Dedicated Exadata Infrastructure. Both workload types (transaction processing and warehouse) can be provisioned on dedicated Exadata infrastructure.
  • Shared Exadata Infrastructure: With this option, you provision and manage only the Autonomous Database, while Oracle handles the Exadata infrastructure deployment and management tasks. Both workload types (transaction processing and warehouse) can be provisioned with shared Exadata infrastructure.


The shared Exadata infrastructure option was previously referred to as serverless deployment.

CPU Scaling

You can scale the database's base number of CPU cores up or down at any time. CPU scaling does not impact performance or require any downtime.

For shared Exadata infrastructure, the auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Scaling takes place without any lag time, and you are only billed for your actual average CPU core usage per hour. Note the following points regarding the auto scaling feature:

  • Auto scaling can be enabled or disabled at any time.
  • The auto scaling status for a database (enabled or disabled) is displayed on the database details page.
  • You can view hourly snapshots of the database's actual CPU usage over the most recent 8 days. This information is available in the Service Console, in the Overview page graph "Number of OCPUs Allocated". For more information, see To view CPU allocation hourly snapshot data for an Autonomous Database.

Storage Scaling

Autonomous Database allows you to scale the storage capacity of the database at any time without impacting availability or performance.

Performance Monitoring Using Oracle Performance Hub

You can monitor and diagnose the performance of an Autonomous Database in the Oracle Cloud Infrastructure Console using the Performance Hub ASH Analytics and SQL Monitoring features. These features provide the same information as the ASH Analytics and SQL Monitoring tools found in Oracle's EM Express, Oracle Management Cloud (OMC), and SQL Developer Web applications. For more information about using these features in the Oracle Cloud Infrastructure Console, see Using Performance Hub to Analyze Database Performance in Oracle Cloud Infrastructure.

Oracle Database Preview Version Availability

Oracle Cloud Infrastructure periodically offers Autonomous Database preview versions of Oracle Database for testing purposes. You can provision an Autonomous Database using preview version software to test applications before the general availability of the software in Autonomous Database. Oracle will notify Autonomous Database customers when preview versions are available. Preview version software is available for a limited time. Databases provisioned with preview version software will display the end date of the preview period at the top of the database details page in the Console. If you are using the Console, you can also see the end date of the preview period in the Create Database provisioning dialog before the database is created.

Preview version software should not be used for production databases or for databases that need to persist beyond the limited preview period. Note that preview databases and their associated resources (including backups) are terminated automatically at the conclusion of the preview period. Oracle will notify customers prior to the conclusion of the preview period regarding the end date of the preview.

Any existing Autonomous Database (including those provisioned with preview version software) can be cloned using a preview version of Autonomous Database. However, preview version databases cannot be cloned using the regular (general-availability) Autonomous Database software.

See Creating an Autonomous Database for details on provisioning a preview version of Autonomous Database.

Oracle Database Versions for Autonomous Database with Shared Exadata Infrastructure

Depending on the region where you provision or clone your database, Autonomous Database supports one or more Oracle Database versions. The time for Oracle Database version availability depends on the region (some regions do not support multiple Oracle Database versions).

When multiple database versions are available, you choose an Oracle Database version when you provision or clone a database.


Always Free Autonomous Database only supports a single Oracle Database version. See Overview of the Always Free Autonomous Database for more information.

For information on current regional availability, see "Oracle Database Versions and Availability by Region" in the Oracle Help Center:  Autonomous Transaction Processing | Autonomous Data Warehouse.

Regional Availability

Autonomous Database is currently available in all regions of the commercial realm. Autonomous Database is currently not available in regions within the Government Cloud realm.

Security Considerations

Data Safe Integration

Oracle Data Safe is a cloud service that enables you to monitor the security posture of your Autonomous Databases. Data Safe helps you discover, protect, and mask sensitive and regulated data. It also helps you assess database users and their authentication information for security risks, and provides auditing and reporting features need for compliance.

Autonomous Databases on shared Exadata infrastructure can be registered with the Data Safe instance in the region containing the Autonomous Database. For information on registering or deregistering a database, see To register or deregister an Autonomous Database with Data Safe.

For information on creating and using Data Safe instances, see the Data Safe Overview.

Service Gateway

Oracle Autonomous Database is one of the Oracle Cloud services that can be privately accessed through a service gateway within a VCN . This means you do not need a public IP or NAT to access your Autonomous Database instance from any of the cloud services within the Oracle Services Network. For example, if you have a Compute instance that uses a VCN with a service gateway, you can route traffic between your Compute instance and an Autonomous Database in the same region without the traffic going over the internet. For information on setting up a VCN service gateway and configuring it to access all supported Oracle Service Network services (which include Autonomous Database), see Access to Oracle Services: Service Gateway.

Access Control Lists (ACLs) for Databases on Shared Exadata Infrastructure

For Autonomous Databases on shared Exadata infrastructure, an access control list (ACL) provides additional protection for your database by allowing only specified IP addresses and VCN s in the list to connect to the database. Specified IP addresses can include private IP addresses from your on-premises network that connect to your database using transit routing and allow traffic to move directly from your on-premises network to your Autonomous Database without going over the internet. See Transit Routing: Private Access to Oracle Services for more information on this method of access.

You can add the following to your ACL:

  • Public IP addresses (individually, or in CIDR blocks)
  • An entire VCN (specified by OCID  )
  • Private IP addresses within a specified VCN (individually, or in CIDR blocks)
  • Private IP addresses within an on-premises network that have access using a transit routing

You can create an ACL during database provisioning, or at any time thereafter. You can also edit an ACL at any time. Removing all entries from the list makes the database accessible to all clients with the applicable credentials. See To manage the access control list of an Autonomous Database on shared Exadata infrastructure to learn how to create, update, or delete an ACL.


If you are using a service gateway and you configure an access control list, you must add the CIDR range to the ACL to enable clients accessing the database through the service gateway to connect to it.

Security Tools for Databases on Dedicated Exadata Infrastructure

Network security groups (NSGs), an optional Networking feature available for databases on dedicated Exadata infrastructure, act as a virtual firewall for your Autonomous Exadata Infrastructure resources. An NSG consists of a set of ingress and egress security rules that apply only to a set of VNICs of your choice within a single VCN. For more information, see the following topics:

Automatic Maintenance

For Autonomous Databases on shared Exadata infrastructure, Oracle manages the automatic maintenance. You can view the next scheduled maintenance in the Console on the details page for your Autonomous Database. For Autonomous Databases on dedicated Exadata infrastructure, see Overview of Dedicated Exadata Infrastructure Maintenance.

Development and Administration Tools

Oracle's SQL Developer Web, Application Express (APEX), and Machine Learning applications are available for Autonomous Databases. For information on how to use these applications and access them from the  Console, see Autonomous Database Development and Administration Tools.

Compartment Quotas for Autonomous Databases

You can use compartment quotas to control how Autonomous Database OCPU and storage resources are allocated to Oracle Cloud Infrastructure compartments. You can use compartment quota policy statements to control OCPU and storage resources by both workload type and Exadata infrastructure type. For example, you can allocate 10 Autonomous Transaction Processing OCPUs on shared Exadata infrastructure to a specific compartment. This would not affect the number of OCPUs available to Autonomous Data Warehouse databases, or databases using dedicated Exadata infrastructure. For more information on using compartment quotas, see Compartment Quotas and Database Quotas.

Using the Oracle Cloud Infrastructure Console to Manage Autonomous Databases

For information on provisioning, managing, and backing up an Autonomous Database in the Oracle Cloud Infrastructure Console, see the following topics:

Additional Autonomous Database Product Information

Autonomous Transaction Processing

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.

Hidden x-ref linking content. Do not remove! This topic has moved. Please update your bookmarks.