Autonomous Database for transaction processing and mixed workloads (ATP)

Simplified data management—with autonomous administration

Auto-provisioning

Deploys fault-tolerant and highly available databases in minutes.

Auto-scaling

Scales compute resources automatically to meet performance and throughput requirements without any downtime. Enables true pay-per-use experience with online dynamic scaling.

Auto-tuning

Configures and tunes databases automatically even as data and schema change over time. The memory configuration, data formats, indexes, and access structures are automatically optimized to improve performance.

Automated backups

Performs weekly full and daily incremental backups of the database in Oracle’s object storage and retains them for up to 60 days to restore and recover to any point in time.

Auto-repairing

Fixes hardware and software faults by continuously monitoring and predicting failures. Requests are immediately redirected to healthy devices, maintaining database performance.

Auto-failover

Eliminates site downtime by maintaining a real-time remote copy of a production database and automatically switching from primary to remote copy using Autonomous Data Guard.

Watch technical deep dive webcast on accelerating developer productivity with autonomous capabilities

Application development made simple with low-code tools and capabilities

Support for relational and nonrelational data models

Natively supports multiple data types including document, graph, spatial, JSON, XML, and more for faster application development. Prevents data fragmentation and reduces data management hassles resulting from siloed data stores.

REST API support for modern application development

Provides database management REST APIs, web interface, and PL/SQL Gateway to REST-enable all your data for simpler and faster access.

No-code/Low-code development

APEX App Dev, Oracle’s low-code application development platform, is built into Oracle Autonomous Database, and eliminates 98% of hand coding. APEX App Dev empowers developers to rapidly build sophisticated applications.

In-database machine learning (ML) algorithms

Provides more than 30 ML algorithms, automated ML functions, and integration with open source Python and R to make it easy to build ML models and analytical dashboards without moving data out of the database.

Self-service tools for API-driven development

Built-in data tools provide self-service data loading, data transformations, and business models, making it easy to load any data, run complex queries across multiple data types, build sophisticated analytical models, visualize information, deliver insights, and ease development of data-driven applications.

Fast cloning

Create fast clones of the entire database or just the metadata, to quickly get started on new projects. Create clones from running database instances or a backup database.

Interoperability with Microsoft Azure

Provides fully supported, multicloud solutions with fast interconnections to Microsoft Azure.

Read the technical brief to see how a fully managed, multimodel, converged database in the cloud is a great choice for most of your applications. (PDF)

Reduce risk with database security

Always-on encryption

Provides automatic encryption for the entire database and for backups with encryption keys that you create and control. This ensures the data is always secure at rest and in motion.

Auto-patching

Patches and upgrades databases for security vulnerabilities with zero downtime. Applications continue to run as patching occurs.

Data privacy

Enables database administrators to perform all administrative tasks without ever seeing customer data. Blocks access to OS or admin privileges to prevent phishing attacks.

Security for sensitive data

Oracle Data Safe, included with Oracle Autonomous Database for transaction processing and mixed workloads, makes it easy to discover sensitive data, evaluate security risks, mask sensitive data, and implement and monitor security controls.

Advanced auditing

Logs all events with minimal impact on performance. You can monitor audits anytime for analysis, forensics, and compliance.

Ensure consistently high performance

High performance

Delivers 80% lower latency and more than 5X throughput than other cloud providers by utilizing database-optimized hardware, automated tuning, and indexing.

Always online

Provides more than 99.95% availability using a combination of Oracle’s Gen 2 Cloud Infrastructure, Oracle RAC, Autonomous Data Guard, and daily automatic backups.

Protection from human error

Oracle Flashback, provided with Oracle Autonomous Database for transaction processing and mixed workloads, instantly rewinds accidental changes to application schemas, protecting users from human errors. It supports recovery at all levels, including row, transaction, and table—and across the entire database.