About Autonomous Databases

Autonomous Databases are fully managed, preconfigured database environments that are created in Oracle Cloud Infrastructure.

Autonomous Databases are cloud databases that deliver end-to-end automation of tasks that are traditionally performed by DBAs, such as provisioning the database and monitoring security, availability, and performance. Using Autonomous Databases, you do not have to configure or manage any hardware, or install any software. After creating an Autonomous Database, you can scale the number of CPU cores or the storage capacity of the database at any time without impacting availability or performance.

Autonomous Databases are of the following types:

  • Autonomous Data Warehouse, which provides an easy-to-use, fully autonomous data warehouse that scales elastically, delivers fast query performance and requires no database administration. It is designed to support all standard SQL and business intelligence (BI) tools, and provides all of the performance of the Oracle Database in an environment that is tuned and optimized for data warehouse workloads. For more information, see Autonomous Data Warehouse.
  • Autonomous Transaction Processing, which is designed to support all standard business applications and delivers scalable query performance. Autonomous Transaction Processing provides all of the performance of the Oracle Database in an environment that is tuned and optimized for transaction processing workloads. For more information, see Autonomous Transaction Processing.

When you create an Autonomous Database, you have the following deployment options:

  • Dedicated Exadata Infrastructure, which is a private database cloud in the public cloud. A completely dedicated compute, storage, network and database service for only a single tenant. Dedicated infrastructure provides for the highest levels of security isolation and governance.
  • Serverless, which is an easy-to-use option that scales elastically and delivers fast query performance. Oracle autonomously operates all aspects of the database life cycle from database placement to backup and updates.

Most tasks related to Autonomous Databases are automated, however, you have to monitor, diagnose, and perform basic application-level administrative tasks. Here's where you can use Oracle Enterprise Manager and ensure:

  • Alert-driven monitoring for visibility into availability and key metrics.
  • In-depth application performance diagnostics and troubleshooting.
  • Insight-driven utilization analysis built on aggregated monitoring, based on historical data.