Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

Autonomous Database Newsletter - April 30-2020

Keith Laker
Senior Principal Product Manager

Autonomous Database
on Shared Exadata Infrastructure
April 30, 2020

ADB Logo

Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:

Don't forget to checkout our "What's New" page for a comprehensive archive of all the new features we have added to Autonomous Database - click here.

To find out how to subscribe to this newsletter click here.

Icon for Oracle PaaS and IaaS Public Cloud Services Pillar Document


NEW - Autonomous Database now comes with an SLA

The service level agreement for ADB has just been published and it applies only to the deployment of an Autonomous Database on shared infrastructure.

The pillar document listed below in the section headed LEARN states that:

Oracle will use commercially reasonable efforts to have the Oracle Cloud Infrastructure – Autonomous Database Services on Shared Infrastructure with a Monthly Uptime Percentage of at least 99.95% during any calendar month (the "Service Commitment").

In the event an Autonomous Database Service on Shared Infrastructure does not meet the "Service Commitment" then customers will be eligible to receive Service Credits. Note - there are specific definitions of key terms in the pillar document (listed below in the section headed LEARN) that you should read and understand.


PDF: Oracle PaaS and IaaS Public Cloud Services Pillar Document (April 2020),  click here.

Autonomous Database information is covered in Category 7, which starts on page 4 with ADB covered on pages 17 and 18.


Icon showing per second billing for Autonomous Database


NEW - Per-Second Billing For Autonomous Database

Autonomous Database instance CPU and storage usage is now billed by the second, with a minimum usage period of one minute. Previously Autonomous Database billed in one-hour minimum increments and partial usage of an hour was rounded up to a full hour.

This change benefits the following types of use cases:

  • Where you only run your ADB instances during work hours and stop instances at end of working day
  • Where you start-stop your instances to run overnight batch jobs
  • Where you have ADB instances which typically have a short lifecycle – sandboxes, QA, training, integration testing instances.

DOC: Per-second billing announcement for ADW,  click here

DOC: Per-second billing announcement for ATP,  click here

DOC: OCI Per-second billing general announcement which covers ADB,  click here

BLOG: Review of per-second billing on OCI,  click here


Autonomous Database offers extended support for SODA documents and collections


NEW - Support for SODA Documents and Collections

Autonomous Database now supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows developers to store, search, and retrieve document collections, typically JSON documents, without using SQL.

It is possible to also access document collections with SQL/JSON operators which means that ADB now combines the simplicity of a document database with the power of a relational database.

The Oracle Cloud Infrastructure console has been updated with a link to access the SODA drivers for several languages and frameworks including: Java, Node.js, Python, Oracle Call Interface, and PL/SQL, as shown below.

Autonomous Database tools panel on OCI console showing access to new SODA drivers

DOC: Using JSON Documents with ADW,  click here

DOC: Using JSON Documents with ATP,  click here

Documentation covers the following key topics:

  • Work with Simple Oracle Document Access (SODA) in Autonomous Database
  • SODA Collection Metadata on Autonomous Database
  • Work with JSON Documents Using SQL and PL/SQL APIs on Autonomous Database
  • Load JSON Documents with Autonomous Database




For examples of using SODA see the following whitepaper:  Developing schemaless applications using the Simple Oracle Document Access APIs.


ADB provides extensions for key IDEs to support common operations


NEW - ADB Extensions for IDEs

ADB extensions enable developers to connect to, browse, and manage Autonomous Databases directly from their IDEs. There are extensions for the following: Eclipse, Microsoft Visual Studio and Visual Studio Code.

Users with permissions to manage the databases can perform a number of actions (depending on their IDE), such as:

  • Sign up for Oracle Cloud
  • Connect to a cloud account using a simple auto-generated config file and key file
  • Create new or clone existing Always Free Autonomous Database, Autonomous Database Dedicated, and Autonomous Database Shared databases
  • Automatically download credentials files (including wallets) and quickly connect, browse, and operate on Autonomous Database schemas
  • Change compartments and regions without reconnecting
  • Start, stop, or terminate Autonomous Databases
  • Scale up/down Autonomous Database resources
  • Restore from backup
  • Update instance credentials and/or license type used
  • Rotate wallets
  • Convert Always Free ADBs into paid ADBs


DOC: IDE Extensions in ADW,  click here

DOC: IDE Extensions in ATP,  click here


Feature Icon


NEW - Stateful Rule Support in Private Endpoints

When configuring a private endpoint one of the steps is to define a security rule(s) in a Network Security Group. This creates a virtual firewall for the Autonomous Database and allows connections to the Autonomous Database instance.

The Network Security Group can now be configured with stateful rules.



DOC: Configure Private Endpoints with ADW, click here

DOC: Configure Private Endpoints with ATP, click here

BLOG: Announcing Private Endpoints in Autonomous Database on Shared Exadata Infrastructure, click here.



Enhancements to How Autonomous Database Can Leverage Data Pump Dump Files


UPDATED - Enhancements to Data Pump Support

Two specific improvements relating to how Data Pump dump files can be used with ADB. It is now possible to:

  • Query Data Pump dump files in the Cloud by creating an external table
  • Use Data Pump dump files in the Cloud as source files to load data

DOC: Query external Data Pump dump files with ADW, click here

DOC: Load Data Pump dump files into an existing table with ADW, click here.


DOC: Query external Data Pump dump files with ATP, click here

DOC: Load Data Pump dump files into an existing table with ATP, click here.






WEBCAST - How to Scale Your Services with Autonomous Database To Infinity

29 April 2020 at 15:00 CET

Join this Oracle Global Leaders webcast to discover directly from Peter Merkert, CTO & Co-Fouder, Retraced GmbH how they are using Oracle Autonomous Database and the benefit they are getting. To register click here.

To learn more, also see the video: How Autonomous & Blockchain Provide A Sustainable Transparent Clothing Supply Chain?


WEBCAST - From BillBoards to Dashboards using ADW and OAC

13 May 2020 at 12:00 PM ET

Join this Oracle Global Leaders webcast to discover directly from Derek Hayden, SVP, Data Strategy and Analytics at OUTFRONT Media, about the role of Autonomous Data Warehouse in the new data platform for OUTFRONT Media moving in the digital age.

Derek will discuss initial success with ADW, OAC and how this platform is being used for OUTFRONT's growth, efficiencies and data management in the out of home advertising industry.

To register click here.

WEBCAST - Building low code application using Oracle Autonomous Database and Application Express

19 May 2020 at 15:00 CET

Join this Oracle Global Leaders webcast to discover directly from Dr. Holger Friedrich, CEO, SumIT how they are using Oracle Autonomous Database and the benefit they are getting.

Oracle Application Express is a powerful low-code web application development framework built-in and ready-to-use with Oracle Autonomous Database. It is instantly available in every provisioned service instance. In this webcast we will explain and demonstrate how sumIT and partner document2relation employ APEX and ATP to provide quick migration services and application development for migrating legacy Lotus Notes applications to the Cloud.

To register click here.


WEBCAST - Smart Shovelling with ADW & APEX

13 May 2020 at 12:00 PM ET

Join our Global Leaders webinar to hear from Frank Hoogendoorn, CDO of MineSense: a technology solution provider for the Mining Industry that combines IoT and machine learning to create "Smart Shovel" technologies that optimize mine operations, all powered by Oracle solutions!

In this Webinar, Frank will explain how MineSense has transitioned from "start-up" to a "scale-up", and how Autonomous Data Warehouse with built-in APEX is enabling rapid business growth with international Mining customers that include some of the world’s largest Copper and Zinc producers. Backed by APEX and ADW, their disruptive ‘smart shovel’ technology collects and analyzes orebody data in real-time, where machine learning based algorithms drive processing decisions to boost mine productivity while reducing energy consumption, all of which leads to more sustainable mining operations. With the flexibility and low cost setup of ADW, the ease of application development and deployment with APEX, and superb on-demand data processing performance, MineSense will talk about how Oracle Solutions, (some even running right on mining shovels!), have been key in setting up a pivotal digital platform, where IT is no longer seen as a business cost but rather a key driver for growth.

To register click here.


oracle.com Icon


Documentation Icon


YCO calculation Icon

TCO Calculator

Shared Dedicated
Cloud Cost Estimator Icon

Cloud Cost Estimator

Autonomous Database
Public What's New Icon

ADB New Features

Autonomous Database
Schema Advisor icon

Schema Advisor

Autonomous Database
Public What's New Icon

Customer Forums



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.