Overview of Autonomous Databases
Oracle Cloud Infrastructure's Autonomous Database is a fully managed, preconfigured database environment with four workload types available, which are: Autonomous Transaction Processing, Autonomous Data Warehouse, Oracle APEX Application Development, and Autonomous JSON Database. 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, and 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 without charge 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.
Always Free databases have only single available version. You can see the version that is being used for your database in the details screen. After a newer Oracle Database version is available in Oracle Cloud Infrastructure, your database will be automatically upgraded during one of your database's upcoming maintenance windows.
To learn about Free Tier Databases, see Oracle Cloud Infrastructure Free Tier. To learn about the details of the Always Free Autonomous Database, see Overview of the Always Free Autonomous Database. To provision an Always Free Autonomous Database, see Creating an Autonomous Database on Shared Exadata Infrastructure.
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 the following workload types:
Autonomous Data Warehouse: Built for decision support and data warehouse workloads. Offers fast queries over large volumes of data.
Autonomous JSON Database: Built for JSON-centric application development. Offers developer-friendly document APIs and native JSON storage.
For a complete product overview of Autonomous JSON Database, see Using Oracle Autonomous JSON Database. Also available in the Oracle Help Center are Autonomous JSON Database tutorials and the JSON Developer's Guide.
Autonomous Transaction Processing: Built for transactional workloads. Offers high concurrency for short-running queries and transactions.
- Oracle APEX Application Development (APEX Service): Optimized for application
developers, who want a transaction processing database for application development
using Oracle APEX, that enables creation and deployment of low-code applications,
including databases. See Oracle APEX Application Development Documentation for
more information about the APEX service and Oracle APEX Application Development Specific
Limitations for a list of use restrictions.Note
You can use the APEX service with each of the other workload types.
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. Both workload types (transaction processing and warehouse) can be provisioned on dedicated Exadata infrastructure. You have the following hardware configuration options:
- System Models: X8M, X8, and X7
- Configurations: quarter rack (maximum for X8M), half rack, and full rack
See Autonomous Exadata Infrastructure Hardware Options for more information about dedicated Exadata infrastructure architecture, features, and hardware specifications.
- Shared Exadata Infrastructure: With this option, you provision and manage only the Autonomous Database, while Oracle deploys and manages the Exadata infrastructure. Both workload types (transaction processing and warehouse) can be provisioned with shared Exadata infrastructure.
Oracle Data Guard for Autonomous Databases with Shared Exadata Infrastructure
Autonomous Database uses a feature called Autonomous Data Guard to enable a standby (peer) database to provide data protection and disaster recovery for Autonomous Databases using shared Exadata infrastructure. For more information, see Using a Standby Database with Autonomous Database.
Per-Second Billing Billing for Autonomous Database Resources
Shared Exadata Infrastructure
Autonomous Database on Shared Exadata infrastructure uses per-second billing. This means that OCPU and storage usage is billed by the second. OCPU resources have a minimum usage period of 1 minute.
Dedicated Exadata Infrastructure
For each Autonomous Exadata Infrastructure instance you provision, you are billed for the infrastructure for a minimum of 48 hours, and then by the second after that. Each OCPU you add to the system is billed by the second, with a minimum usage period of 1 minute.
Private Endpoint for Autonomous Databases with Shared Exadata Infrastructure
When you provision an Autonomous Database with Shared Exadata infrastructure, you can configure the network access so that the database uses a private endpoint within one of your tenancy's virtual cloud networks (VCNs). When you use a private endpoint, your database is only accessible via the IP address of the associated private endpoint. For more information, see Autonomous Database with Private Endpoint on Shared Exadata Infrastructure.
Oracle Autonomous Database offers two types of CPU scaling, manual and automatic. Manually scaling a database resets the base number of CPU cores that remain available to the database at all times. Optionally, you can enable automatic scaling (referred to as auto scaling) for your database. Auto scaling allows the Autonomous Database to automatically add more CPU cores to the base number of cores during periods of high demand, and then automatically reduce the number of cores back to the base number as demand decreases.
You can manually scale the database's base number of CPU cores up or down at any time. Note the following:
- CPU scaling does not require any downtime.
CPU utilization information is available for all Autonomous Databases on the database details page in the Metrics section. CPU utilization is reported as a percentage of available CPUs, aggregated across all consumer groups.
For databases using shared Exadata infrastructure, you can also view hourly snapshots of the database's CPU usage (actual number of cores allocated) 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 OCPU allocation hourly snapshot data for an Autonomous Database.
- For databases using dedicated Exadata infrastructure, you can assign a fractional OCPU core value from 0.1 to 0.9 to databases that do not need a full core. This allows you to over-provision databases at the system level and run more databases on each infrastructure instance. See Add CPU or Storage Resources to a Dedicated Autonomous Database for more information.
Autonomous Database's 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 is enabled by default and 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.
- The base number of OCPU cores allocated to a database is guaranteed. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance, and is further limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands. Available OCPU cores are enabled on a "first come, first served basis" for autoscaling databases sharing an Autonomous Exadata Infrastructure instance.
The following table illustrates OCPU core availability for a single database on an X8 quarter rack dedicated Exadata infrastructure instance. As you increase the database's base core count from 1 to 40 cores, the maximum core count scales until it reaches the hardware limit of 100 OCPUs. The final column, which shows the remaining available OCPUs that can be allocated to additional databases, assumes that no other databases exist on the quarter rack instance.
Example: OCPU auto scaling for a single database on an X8 quarter rack as base OCPU is increased
|Base OCPU core count||Maximum OCPU core count||OCPU cores remaining|
The following table illustrates OCPU core availability for four databases on an X8 half rack dedicated Exadata infrastructure instance. The hardware limit is 200 OCPUs. The Base OCPU count for each database is guaranteed to be available to the database at all times. In the example, the three database with auto scaling enabled are in contention for the 60 available cores that are not allocated to any database as base cores. Databases Sales and Development each auto scaled to take a combined 140 OCPU, and database Chicago (with auto scaling disabled) is using its 10 base OCPU. That leaves only 50 OCPU remaining in the half rack hardware instance, and the base OCPU of database HR is 50. Therefore, database HR cannot auto scale up until cores are released by the other auto scaling databases.
Example: OCPU auto scaling for four databases on an X8 half rack
|DB Name||Auto Scaling||Base OCPU Count (Guaranteed OCPU)||Maximum OCPU core count||OCPU Enabled During Load|
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
Performance Hub provides in-depth monitoring capability for running Oracle database performance analysis and tuning. It is used in multiple Oracle database monitoring infrastructures, including Enterprise Manager, OMC, SQL web developer, Autonomous Database services
Performance Hub includes the following features:
- The ASH (Active Session History) Analytics feature shows ASH analytics charts that you can use to explore ASH data. It also displays real-time SQL data for both OCI and external databases.
- The SQL Monitoring feature displays monitored SQL statement executions by dimensions, including Last Active Time, CPU Time, and Database Time, and provides information for monitored SQL statements, including Status, Duration, and SQL ID. It displays real-time monitored SQL data for both OCI and external databases.
- The Workload performance monitoring feature provides detailed real-time and historical performance data of CPU Statistics, Wait Time Statistics, Workload Profile, and Sessions.
- The Blocking Sessions feature provides information about blocking and waiting sessions for a selected Autonomous Database. It includes procedures to display detailed information about the sessions, and explains how to end sessions as needed.
- The ADDM (Automatic Database Diagnostic Monitor) feature displays findings and recommendations for performance problems.
Detailed information about these features and how to use them in the Oracle Cloud Infrastructure Console is located in Using Performance Hub to Analyze Database Performance.
Operations Insights is a cloud-native service that enables users to make informed, data-driven, Oracle Autonomous database resource and performance management decisions. See To enable or disable Operations Insights on an Autonomous Database for information about managing Operations Insights.
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 on Shared Exadata Infrastructure 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.
Always Free Autonomous Databases can be provisioned with either version 19c or version 21c, depending on the region. Most regions offer both versions. Note that Always FreeAutonomous Databases can only be provisioned in the home region of your tenancy or account. See Overview of the Always Free Autonomous Database for more information.
Upgrading a Database
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.
Safeguard Your Data with Data Safe on Autonomous Database
Oracle Data Safe is a fully-integrated, regional Cloud service providing features that help you protect sensitive and regulated data in your Autonomous Transaction Processing database. See the Data Safe documentation for more information.
Private Access Using a Service Gateway
Autonomous Database is one of the Oracle Cloud Infrastructure 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 VCNs 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 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 either dedicated or shared Exadata infrastructure to learn how to create, update, or delete an ACL.
If you want to only allow connections coming through a service gateway you need to use the IP address of the service gateway in your ACL definition. To do this you need to add an ACL rule using the CIDR source type and the value 240.0.0.0/4. Note that this is not recommended. Instead, you can specify individual VCNs in your ACL definition for the VCNs you want to allow access from. See Access to Oracle Services: Service Gateway for more information.
Note the following about using an ACL with your Autonomous Database:
- When you restore a database the existing ACLs are not overwritten by the restore.
- The network ACL applies to the database connections and Oracle Machine Learning notebooks. If an ACL is defined and you try to login to Oracle Machine Learning from a client whose IP is not specified on the ACL you will see a "login rejected based on access control list set by the administrator" error.
- Oracle Application Express (APEX), RESTful services, and Oracle Database Actions are subject to ACLs. You can create rules specifying Virtual Cloud Networks, Virtual Cloud Network OCIDs, IP addresses, or CIDR blocks to control access to these tools.
- The Autonomous Database Service console is not subject to ACL rules.
If you have a private subnet in your VCN that is configured to access the public internet through an NAT gateway, you need to enter the public IP address of the NAT gateway in your ACL definition. Clients in the private subnet do not have public IP addresses. See NAT Gateway for more information.
Network Security Groups for Databases Resources That Use Private Endpoints
Network security groups (NSGs) are an optional Networking security feature available for dedicated Exadata infrastructure and databases on shared Exadata infrastructure that use private endpoints. NSGs act as a virtual firewall for your Autonomous Database 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:
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 Manage Autonomous Container Databases and Manage Autonomous Exadata Infrastructure Resources.
Development and Administration Tools
Oracle's Database Actions, 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 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
For in-depth documentation on using and managing your Autonomous Transaction Processing database on shared Exadata infrastructure, see the following topics:
- Getting Started with Autonomous Database
- Connecting to Autonomous Database
- Loading Data with Autonomous Database
- Querying External Data with Autonomous Database
- Creating Dashboards, Reports, and Notebooks with Autonomous Database
- Managing Users on Autonomous Database
- Managing and Monitoring Performance of Autonomous Database
For information on using a database client to manage your database, see Connect Autonomous Database Using a Client Application.
Autonomous Database Tutorials
Autonomous Database Quickstart
Learn about Autonomous Database on Shared Infrastructure and learn how to create an Autonomous Database in just a few clicks. Then load data into your database, query it, and visualize it.
- Provision Autonomous Database
- Load Data
- Query and Visualize Data
- Manage and Monitor
Analyzing Your Data with Autonomous Database
Connect using secure wallets and monitor your Autonomous Database instances. Use Oracle Analytics Desktop to visualize data in Autonomous Database. Use Oracle Machine Learning Notebooks to try your hand at predictive analytics.
- Provision Autonomous Database
- Load Data
- Query and Visualize Data
- Manage and Monitor
- Machine Learning Notebooks
- Build a Machine Learning Algorithm
Autonomous JSON Database is available on shared Exadata infrastructure. For in-depth documentation on using and managing your Autonomous JSON Database, see the following topics:
- Get Started Using Autonomous JSON Database
- Use SQL Developer Web with JSON Collections
- Develop RESTful Services
- Build an Application
- Load JSON Documents
- Code for High Performance
See JSON Developer's Guide for information on using Autonomous JSON Database as a part of application development.
Oracle APEX Application Development is available on Autonomous Database for shared Exadata infrastructure. For in-depth documentation on using and managing your Oracle APEX Application Development instance, see the following topics: