All Things Database: Education, Best Practices,
Use Cases & More

Oracle Autonomous Database - Dedicated

Kris Bhanushali
Sr. Principal Product Manager

Oracle recently introduced the dedicated infrastructure option to its Autonomous Database cloud service. This offering is aimed at enterprise customers looking to leverage the agility of a public cloud while keeping the performance and security of an on-premise database install. Essentially, this is akin to having your own private database cloud in a public cloud. 

Key Aspects of the service are - 

1. Dedicated Exadata Infrastructure

Exadata was introduced by Oracle in 2007 as an engineered system platform for running Oracle databases. Over the years it has been widely adopted as a high-performance, highly available database infrastructure and is considered a standard platform for any significant enterprise Oracle database. All autonomous database services are hosted on Exadata. Half and full rack shapes are expected to be announced later this year.

2. Fully managed, autonomous service

All maintenance activities such as patching, regular backups, database availability are managed by Oracle automation and operations. Machine learning based monitoring algorithms keep track of workload performance and can self-tune databases for optimal application performance. The Automatic Indexing features allows customers to run net new applications without worrying about SQL Plan regression and even reduce the number of unwanted indices in existing applications. 

Customers have a choice of scheduling their maintenance window down to the hour to ensure patching operations do not coincide with critical business functions although all patching operations happen online with minimal application disruption using RAC rolling updates and Transparent Application Continuity.

3. Multiple levels of Isolation

Since each customer's databases reside on a separate piece of hardware, that is the highest level of physical isolation available. Besides, there is isolation at the virtual network layer ensure each Exadata infrastructure and its databases are in a separate, private, virtual network (VCN) with no public IP's and controlled access via security list whitelisting at the host, source ports and protocol level. Further, each database container (CDB) and its autonomous database instances are isolated from each other and secured via lockdown profiles such that each database runs in the container as a separate entity with its own share of CPU cores, memory and storage space.

4. Developer ready service

Developers can leverage the ease of deployment and simplicity to be up and running with a full development stack within minutes. The OCI Marketplace even provides a developer ready compute image configured with language drivers, sql developer, OCI CLI and Terraform to build robust apps on ATP dedicated. 

Apex comes built into the service. Simply deploy a database instance and grab the Apex URL from the web console. 

A light weight version of SQL Developer is also built into the service providing an web based interface to the database.

5. Simplified Licensing

The service has a low cost of entry at a fraction of the cost of owning a 1/4 rack of Exadata on-prem. Customers may also use their existing, on-premise licenses to further reduce the OCPU/hr cost or pay a flat per hour fee for the number of cores used. All database options such as RAC, multi-tenant, Advance Security, Flashback, Compression and Data Vault are included in the subscription option.


The dedicated deployment option of the autonomous database service definitely brings a high performance database platform to any business that desires enterprise grade service levels but does not want the associated administrative cost. 

More information on the Autonomous Dedicated offering is available at this recorded technical webcast by Autonomous Product Management





Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.