Autonomous Transaction Processing

Oracle Autonomous Transaction Processing is a fully automated database service optimized to run transactional, analytical, and batch workloads concurrently. To accelerate performance, it’s preconfigured for row format, indexes, and data caching while providing scalability, availability, transparent security, and real-time operational analytics. Application developers and DBAs can rapidly, easily, and cost-effectively develop and deploy applications without sacrificing functionality or atomicity, consistency, isolation, and durability (ACID) properties. Built on Oracle Database and Oracle Exadata, Autonomous Transaction Processing is available on Oracle Cloud Infrastructure (OCI) for serverless or dedicated deployments and on-premises with Exadata Cloud@Customer and OCI Dedicated Region.

Oracle Database@Azure 首度在歐洲登場

客戶現在可以在 Microsoft Azure 德國中西部區域註冊 Oracle Database@Azure。Oracle 和 Microsoft 已宣佈推出計畫,在更多雲端區域 (包括印度、義大利、瑞典和阿拉伯聯合大公國) 提供服務,使 Oracle Database@Azure 的全球預計供應範圍增加到 15 個區域。

Autonomous Transaction Processing features

Simplified data management—with autonomous administration


Deploys fault-tolerant and highly available databases in minutes.


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


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.


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


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

Oracle Autonomous Database Data Studio provides built-in 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.

Build with Oracle Autonomous Database@Azure

Combine Microsoft Cloud capabilities and Azure application development tools and frameworks with the power of Oracle Database services in OCI.

Integrated generative AI capability

The Select AI feature enables a capability that lets users ask questions in natural language and have Autonomous Database interpret them. Users of this capability don’t need any knowledge of the underlying data or SQL language.

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.


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 Transaction Processing, 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.995% availability* using a combination of Oracle’s Gen 2 Cloud Infrastructure, Oracle Real Application Clusters, Oracle Autonomous Data Guard, and daily automatic backups.

Protection from human error

Oracle Flashback, provided with Oracle Autonomous Transaction Processing, 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.

*The service level agreement (SLA) for 99.995% availability assumes the use of Autonomous Data Guard. The SLA is 99.95% availability when Autonomous Data Guard isn’t enabled.

View all customer successes

Oracle Autonomous Transaction Processing customer successes

Learn how customers are using Oracle Autonomous Database for faster transaction processing to transform their business.

  • CERN Openlab logo
  • Grupo DPSP logo
  • Mestec logo
  • Siemens logo
  • Strands logo
  • Surdell and partners logo
  • consis international logo
  • bbva logo
JASCI logo

“With Oracle Autonomous Database, JASCI is revolutionizing logistics so our customers can deliver orders of an ever-expanding product line faster and successfully compete in the age of next-day shipping.”

—Craig Wilensky, CEO, JASCI Software

Oracle Autonomous Transaction Processing use cases

MAY 2, 2024

Try Oracle Database 23ai for Free

George Lumpkin, Vice President of Product Management, Oracle

With the new 23ai release of Autonomous Database Free Container Image and Autonomous Database Free Tier, developers can choose the free development approach best suited for their needs. Develop locally using the container image or develop in the cloud on OCI. Discover how you can access the free development options and start innovating with Oracle Database 23ai features such as AI Vector Search and JSON Relational Duality in combination with Autonomous Database’s rich set of tools and features including Data Studio and Select AI.

ATP resources

Oracle Autonomous Transaction Processing documentation

Explore Oracle Help Center for product documentation and other resources to deploy Oracle Autonomous Transaction Processing.

Cloud Learning

Get started with Oracle Autonomous Transaction Processing

Try Oracle Autonomous Transaction Processing for free

Explore Oracle Autonomous Transaction Processing with $300 in free credits and Always Free instances.

Experience Autonomous Transaction Processing

Get hands-on experience in Autonomous Transaction Processing use cases with Oracle LiveLabs.

Get Oracle-certified

Get certified anywhere, anytime with online proctored testing.

Contact us

Interested in learning more? Contact one of our industry-leading experts.