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.

Categories & Use Cases

Media

Autonomous Transaction Processing Database takes automatic backups

Provisioning a new Autonomous Transaction Processing is simple

Autonomous Transaction Processing Database Console

Auto scaling and manual scaling options of the database

1 / 4

Peter Merkert

CTO (Chief Technical Officer) in Information Technology at retraced GmbH (1-10 employees employees)

Pros

One click deploy
Self-maintaining
Scalability of CPUs on demand on the fly
Additional storage on demand on the fly
Backups without interruption

Cons

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

Return on Investment

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