Tag Archives: Oracle Cloud Services

Introduction to Autonomous Database in Oracle Cloud Infrastructure

Oracle Cloud Infrastructure:(OCI) Autonomous Database terms explained

It is an enterprise cloud, capable of running most workloads. Highest, most consistent performance Low, predictable pricing Automation, innovation.
The autonomous database service is hosted in OCI. Oracle Cloud is hosted in regions and availability domains.

Region: is composed of one or more availability domains. It is like a geographical area.
Availability Domain: has one region only. It is like a data center. In the region, we have availability domains.
Fault domain: is a grouping of hardware and infrastructure within the availability domain. Each availability domain contains 3 fault domains. The fault domain is used to protect against unexpected hardware failure and protect from planned and unplanned downtime like hardware upgrades, software upgrades, etc.

Key features:

  1. Self-driving
  2. self-security
  3. self-healing

Autonomous database :
It is the integration of the Oracle database running on the EXADATA platform with complete infrastructure automation and fully automated data center operations.
Automated data operation includes provisioning, patching, upgrading, and online backup, monitoring, scaling, diagnosing, performance tuning, optimizing, testing, and change management of complex applications and workloads, automatically handling failure and errors.

The Autonomous Database of Oracle Cloud Infrastructure is a pre-configured database environment fully managed with two types of workload available,

  1. Autonomous Transaction Processing
  2. Autonomous Data Warehouse.

The Autonomous Transaction Processing workload type sets up the database for a transactional workload, targeting high volumes of random data access.

The Autonomous Data Warehouse workload type configures the database for decision support or data warehouse workload, with a deviation for large data scanning operations.

Automatic managed services included:
Backing up the database
Patching the database
Upgrading the database
Tuning the database

Deeper customer isolation
Data encryption end to end
Network protection
Verifiable security
Encryption default
Stores all data in an encrypted format.
All connections with authentication and SSL certificate
Encrypted store keys in the wallet
In ADB, no login allow to OS, and no sys-dba or root login allow.
Auditing is enabled by default in autonomous databases, login failures, user changes, grant creation, etc.

Innovate faster with lower cost.
cut the runtime cost to 90%
eliminate the total stack administrator cost.
Ensure data safety
eliminate cyber attack
server level objective t0 99.95%

Automatic tuning:
ADB is a completely self tunning service.
Physical schema tunning is not required and not recommended
The table does not need to be partitioned or configured for in memory
indexes do not need to be created
compression does not need to be specified
tablespace does not be created.

Automatic index: It is used to create secondary indexes, not primary indexes
Backup is maintained and scheduled on a nightly basis to database backup cloud service. retention is 60 days by default
Patching: patching is done once a quarter. It does not affect the availability of DB.

Autonomous Database Free Service:
Free The Autonomous Databases have 8 GB of memory, 20 GB of storage, and 1 OCPU and can be configured to workloads in Autonomous Transaction Processing or Autonomous Data Warehouse.
we can configure up to 2 ADB.

Preview version:
Oracle Cloud Infrastructure offers periodic preview versions of the Autonomous Database Oracle Database for testing purposes.


  1. You can scale the number of CPU cores or the storage capacity of the database at any time without affecting availability or performance.
  2. The wallet can be downloaded from the service console or using REST APIs
  3. There is no need to configure or manage any hardware or install any software.