Skip to main content
Oracle Autonomous Transaction Processing

Oracle Autonomous Transaction Processing


What is Oracle Autonomous Transaction Processing?

Oracle offers the Autonomous Transaction Processing, supporting database self-repair and maintenance with machine learning to eliminate human labor, human error, and manual tuning.

Read more
Recent Reviews
Read all reviews


Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation


View all pricing

Transaction Processing


OCPU Per Hour

Exadata Storage


Per Terabyte Per month

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visit…


  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is Oracle Autonomous Transaction Processing?

Oracle Autonomous Transaction Processing is a cloud database service aimed at eliminating the complexity of operating and securing high-performance databases. The service automates database operations from provisioning, configuring, tuning, scaling, securing, patching, upgrades, backup to maintenance and repairing of databases. It natively supports multiple data types including relational, document, graph, spatial, JSON, and XML for faster development of simple web apps to large, sophisticated applications that are critical for business operation.
The service includes all of Oracle’s advanced database options, such as real application clusters (RAC), multitenant, partitioning, in-memory, advanced security, and advanced compression.
Autonomous Transaction Processing service is available in both the Oracle public cloud or on the user's own data center on Exadata Cloud@Customer.
For more information visit:
Oracle Autonomous Transaction Processing
For tutorials on how to use Autonomous Transaction Processing visit:
Oracle Autonomous Transaction Processing Workshops

Oracle Autonomous Transaction Processing Features

Database-as-a-Service Features

  • Supported: Automatic software patching
  • Supported: Database scalability
  • Supported: Automated backups
  • Supported: Database security provisions
  • Supported: Monitoring and metrics
  • Supported: Automatic host deployment

Additional Features

  • Supported: Automated Tuning
  • Supported: Support for relational and non-relational data models
  • Supported: REST API support for modern application development
  • Supported: No-code/Low-code tool embedded
  • Supported: In-database machine learning (ML) algorithms
  • Supported: Fast cloning
  • Supported: Security for sensitive data with Oracle Data Safe
  • Supported: Advanced auditing
  • Supported: High performance and availability above 99.95%
  • Supported: Protection from human error with Oracle Flashback

Oracle Autonomous Transaction Processing Screenshots

Screenshot of Autonomous Transaction Processing Database takes automatic backupsScreenshot of Provisioning a new Autonomous Transaction Processing is simpleScreenshot of Autonomous Transaction Processing Database  ConsoleScreenshot of Auto scaling and manual scaling options of the database

Oracle Autonomous Transaction Processing Videos

Oracle Autonomous Transaction Processing Competitors

Oracle Autonomous Transaction Processing Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux
Mobile ApplicationNo
Supported CountriesGlobal
Return to navigation


View all alternatives
Return to navigation

Reviews and Ratings


Attribute Ratings


(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Peter Merkert | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We use the Oracle Autonomous Transaction Processing to handle all our data for our underlying microservice architecture. A decision for the architecture was not to maintain a single database per service, but have one database handle all data across all services. The database required an easy scalability possibility and as there were not DevOps hired to maintain databases, it must be a fully self-maintaining out of the box solution - hence: autonomous. The Oracle Autonomous Transaction Processing spins up in less than 5 minutes, is scalable on-demand, runs backups on the fly and does all updates automatically without interruption.
  • One click deploy
  • Self-maintaining
  • Scalability of CPUs on demand on the fly
  • Additional storage on demand on the fly
  • Backups without interruption
  • Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
  • The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections
If your company's value is not increased by maintaining databases, you should use the ATP.
  • Approx 100 times faster spin up than manual setup of an Oracle DB
  • 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
I started using Oracle Autonomous Transaction Processing a few months ago, to host a small APEX app designed and developed by me to track pending/ongoing tasks. Right now I'm the only real user of the application, but a couple of colleagues have started testing it to include their tasks on it, and they will probably start using the app (with some changes and enhancements) in the short term.
  • Quick and simple to deploy (less than 5 steps to create a new instance)
  • No administrative tasks (backup, re-sizing) required
  • None significant to be mentioned
As with any cloud service, the main advantage of Oracle Autonomous Transaction Processing is the ability to scale up (and down, if required), thus reducing initial costs. You can start with a simple 1 CPU and 20Gb instance for free, and scale up to meet your requirements with some simple clicks. You do not have to worry about administrative tasks (OS installation and configuration, storage provisioning, software installation/upgrade, maintenance, etc.).
  • Using the free tier allows me to develop and test the APEX app with no cost.
  • Changing it from a single-user to a department tool is simple.
Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.
  • Price
  • Product Usability
Having the chance of deploying APEX applications was the most important factor to choose Oracle Autonomous Transaction Processing over other cloud based databases.

Since this is a personal development that may be used by some areas of our development center, the chance of using it for free (with Oracle Cloud Free Tier) was also a main factor taken into account.
Actually, I do not think I would change anything.
  • Database creation / deployment is quick and simple
  • APEX configuration is simple and quick
  • I did not find anything too complex to perform.
Yes, but I don't use it
You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.
Return to navigation