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

Autonomous Database Newsletter - September 03, 2020

Keith Laker
Senior Principal Product Manager
September 03, 2020

Latest Newsletter For
Autonomous Database
on Shared Exadata Infrastructure



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

Note: some new features are only available with 19c. To get the most from Autonomous Database, upgrade to 19c as soon as possible. There is more information about how to upgrade existing 18c instances to 19c here, for ADW and here, for ATP.

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 creating a standby dataabase


NEW - Creating A Refreshable Clone

Autonomous Database provides cloning where you can choose to create a full clone of the active instance, create a metadata clone, or create a refreshable clone.

With a refreshable clone the system creates a clone that can be easily updated with changes from the source database.

A refreshable clone allows the following:

  • Maintain one or more copies of the source database for use as read-only databases. A clone database is available when needed, and when the data needs to be updated, simply refresh the clone from its source database.
  • Share copies of a production database with multiple business units. For example, one business unit might use the source database for ongoing transactions and another business unit could at the same time use the refreshable clone database for read-only operations.

Refreshable clones allow customers to spread the cost of database usage across multiple business units. They can bill the different units separately, based on their usage of one or more refreshable clones.

Console view of a refreshable clone

Illustration shows a click-through demo for creating a new refreshable clone.

If an Autonomous Database is the source for a refreshable clone or clones then you can view the list of refreshable clones via the Resources area, select "Refreshable Clones" as shown below.

OCI console view of refreshable clones associated with a specific ADB instance

Illustration shows the OCI console view of refreshable clones associated with a specific ADB instance.


PDF: Overview of Refreshable Clones, including click-through demo, click here.

DOC: About Refreshable Clones for ADW click here.

DOC: About Refreshable Clones for ATP click here.


Visit the LiveLabs home page for a list of all available Autonomous Database labs - click here.




Icon for SQL Developer Web


ENHANCEMENTS - Updates to SQL Developer Web UI

Autonomous Database comes with a built-in SQL Developer Web. The UI for this web console has just been updated.

Autonomous Database uses pre-set consumer groups/resource plans (high, medium, low, tp and tpurgent) which determine memory, CPU, and the degree of parallelism for queries and scripts.

In the past SQL Developer Web connections were defaulted to the LOW consumer group. With this latest update it is now possible to select any of the available consumer groups when using the worksheet.

SQL Developer Web UI showing how to select ADB resource group

Illustration shows SQL Developer Web UI for selecting a consumer group.


The latest UI also provides a simpler experience for managing users: create, edit, grant roles & privileges, REST Enable accounts, view accounts where the password is about to expire and unlock an account.

SQL Developer Web UI showing how to select ADB resource group

Illustration shows SQL Developer Web UI for managing ADB users.


BLOG: Exploring the latest version of SQL Developer Web in the Oracle Autonomous Database, click here.




Icon for SQL in Autonomous Database


NEW - SQL Macros now in ADB

What is a SQL Macro? It is a new and unique way for SQL developers to encapsulate complex processing which can then be reused within SQL statements. Unlike bespoke PL/SQL functions, SQL Macro code is transparent to SQL Optimizer – which brings big benefits since there is no overhead for context switching!

There are two types of SQL Macros:

  • TABLE expressions used in a FROM-clause
  • SCALAR expressions used in SELECT list, WHERE/HAVING, GROUP BY/ORDER BY clauses

Initially only TABLE macros will be available within Autonomous Database. Support for SCALAR macros is coming soon!


PDF: Overview presentation for SQL Macros, click here

VIDEO: 21st Century SQL: using SQL pattern matching and SQL macros - at the same time! click here.

MOS: How To Identify the SQL Macros in Oracle Data Dictionary 19.7 Onwards (Doc ID 2678637.1).

DOC: SQL_MACRO Clause 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.