Oracle Autonomous Transaction
Processing (ATP)
Oracle Autonomous Transaction Processing (ATP)
Introduction
• Cloud Database with high performance and high availability.
• eliminates the complexity of operating
• automates provisioning, configuring, tuning, scaling, patching, encrypting, and repairing of databases.
• includes all of Oracle’s advanced database options, such as real application clusters (RAC), multitenant,
partitioning, in-memory, advanced security, and advanced compression
• Available both on Oracle Public Cloud and as well Customer premises as Exadata Cloud@Customer
Autonomous Operations
• Auto-Provisioning – Deploys highly available and fault tolerant Database instance within few minutes
• Auto-Scaling - Dynamic scaling where compute resources are scaled automatically to enhance the performance
• Auto-Tuning – Since Data and Schema changes over time, hence the memory configuration, data formats, indexes,
structures are automatically optimized to improve performance.
• Auto-Backups – Performs weekly full and daily incremental backup in the object storage an retained for 60 days to
restore and recover at any point in time
• Auto-Repairing – Fixes hardware and software faults by continuously monitoring and predicting failures. Circuit
break to a healthy device to ensure high availability.
• Auto-Failover – Maintains a real-time remote copy of the production database and can automatically switch over to
remote copy using Autonomous Data Guard and that eliminates
Oracle Autonomous Transaction Processing (ATP)
ATP vs Oracle DBaaS vs Oracle On-premise Database
Oracle ATP Oracle DBaaS Oracle On-Prem Database
• Autonomous, managed by • Automated • Customer managed
Oracle
• Hosting comes with three flavors • Hosted on Customer Data center
• Hosting comes with two flavors (Traditional H/W or Exadata
• Hosted on VM/ Bare Metal Machines)
• Hosted on Public Cloud with servers in OCI. Customer
two types – Shared and Managed • Can be Private
Dedicated.
• Hosted on Oracle Managed • Can be made Public
• Exadata Cloud hosted on on VM/ Bare Metal servers
Client’s data center. in OCI • Exadata Cloud hosted on Client’s
data center, managed by Oracle
• Highly Available • Sensitive and Highly (On-premise version of Oracle
available data hosted on ATP)
• Doesn’t have access to backend Exadata CS in Public Cloud
DB file server • Does have access to backend
• Does have access to backend DB file server
• Data Files are imported/ DB file server
exported from Object storage • Data Files are imported/
• Data Files are imported/ exported from backend DB file
exported from backend DB file server
server