Table of Contents

Oracle Autonomous Database

An autonomous database is a cloud database that uses ML to automate database optimization, security, backup, updates, and other routine administrative tasks traditionally performed by database administrators. Unlike traditional databases, autonomous databases perform all of these tasks but do not require human intervention.

user can define backup buckets and staging buckets (storage), to store his own backup pieces and staging files for recovery points if needed.
oracle autonomous database can be monitored and managed by APIs and UI tools such as Enterprise Manager Cloud Control, SQL developer, Oracle machine learning web-based tool (OML)

After provisioning, you can scale the number of CPU cores or the storage capacity of the database at any time without impacting availability or performance

Autonomous Database Workload types

An autonomous database consists of two key elements that align with workload types.
Autonomous Datawarehouse(ADW):

This is like the oracle Datawarehouse database type on-premise
It is built for decision support and data warehouse workloads.
Offers fast queries over large volumes of data and can perform query scans on millions of rows

Autonomous Transaction Processing(ATP)

It is like OLTP and Built for transactional workloads which enable time-based transactional processes such as real-time analytics, personalization, and fraud detection.
It allows for simple application development and deployment.
It is scalable to business needs

Autonomous JSON Database

It is just like Oracle Autonomous Transaction Processing but specialized in developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents
it is currently available on shared Exadata infrastructure.

Oracle APEX Application Development (APEX Service)

This database is optimized for application developers who require a transaction processing database for use with Oracle APEX.
It enables the development and deployment of low-code applications such as databases.

There are two options for deploying an autonomous database.
Serverless

With this option, you simply select what type of database you want (Data Warehouse or Transaction Processing), and which region in the Oracle Cloud your database should be deployed
You also select the computing and storage resources and then Oracle automatically takes care of everything for you.
Here Oracle deploys and manages the Exadata infrastructure

You can also configure the network access so that the database uses a private endpoint within one of your tenancy’s virtual cloud networks (VCNs).and then your database is only accessible via the IP address of the associated private endpoint.

Dedicated

Dedicated Exadata infrastructure offers multitenant database architecture, allowing you to create and manage multiple Autonomous Databases within a single database system
You can customize the software update/patching policy etc.
Both workload types (transaction processing and warehouse) can be provisioned on dedicated Exadata infrastructure

Maximum database uptime, performance, and security―including automatic patches and fixes
Elimination of manual, error management tasks through automation
Reduced costs and improved productivity by automating routine tasks

Reducing the number of DBAs needed to manage its databases
Machine learning helps in many ways
- It automatically and continuously patches, tunes, back up, and upgrades the system without manual intervention all while the system is running
- Using pattern recognition, hardware failures are automatically predicted without long timeouts. IOs are immediately redirected around unhealthy devices to avoid database hangs. Continuous monitoring for each database automatically generates service requests for any deviation.