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

Autonomous Database Newsletter - June 4-2020

Keith Laker
Senior Principal Product Manager

Autonomous Database
on Shared Exadata Infrastructure
June 04, 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 REST Data Services


NEW - ADB now supports Customer Managed Oracle REST Data Services

When you use the default ORDS on Autonomous Database, you cannot modify any of the ORDS configuration options. For example, with the default configuration connections for ORDS are preconfigured to use the LOW database service.

You can now use a customer managed environment if you want manual control of the configuration and management of Oracle REST Data Services.



DOC: About Customer Managed Oracle REST Data Services on ADW, click here.

DOC: About Customer Managed Oracle REST Data Services on ATP, click here.

DOC: Installing and Configuring Customer Managed ORDS on Autonomous Database, click here.

VIDEO: ORDS 101, click here.





BLOG: Examples of how to use REST, click here (see section marked "Examples").

GITHUB: Sample code repository, click here.


Performance Speedometer Icon


NEW - Workload Metrics on Performance Hub

Performance Hub has been expanded to include a new tab, "Workload". This can be used to monitor the workload in the database and helps the user identify performance spikes and bottlenecks.

There are 4 regions in this tab: CPU Statistics, Wait Time Statistics, Workload Profile, and Sessions. Each region contains a group of charts that indicate the characteristics of the workload and the distribution of the resources, as shown below.

Autonomous Database Performance Hub console showing new workload metrics

IMAGE - view the screenshot of the new Workload tab containing the four regions and their associated charts are displayed - click here.


DOC: See section on "To navigate to Performance Hub in the Oracle Cloud Infrastructure Console interface of an Autonomous Database", click here


Cloud Admin icon


NEW - Performance Hub Now Has a Timezone Selector

A time zone control has been added to Performance Hub. This will allow users to view data using an alternate time zone to UTC. They will have the choice of viewing data using either UTC (default), the time zone of their browser client, or the time zone of the database.

Autonomous Database Performance Hub panel showing new timezone selector

ADB provides extensions for key IDEs to support common operations


NEW - Latency Metrics Now Available in Service Metrics

The Database Service Metrics information help Cloud Admins measure useful quantitative data about their Autonomous Databases. This list of available metrics now includes two new latency metrics:

1) Connection latency - Time taken (in milliseconds) to connect to an Autonomous Database that uses shared Exadata infrastructure in each region from a Compute service virtual machine in the same region.

2) Query latency/response time - Time taken (in milliseconds) to display the results of a simple query on the user's screen.

Note - the tests to measure connection latency and query latency are not run against any customer instances.

Within the Service Metrics console, it is possible to define and publish alarms against these new metrics.

Service Metrics OCI console showing new latency metrics

IMAGE - view the screenshot of the new latency metrics graphs on Service Metrics console- click here.



Overview of Events Service, click here.

List of all the Autonomous Database events, click here.


Cloud Admin icon


NEW - SQL access to tenancy details for ADB

When you file a service request for Autonomous Database, you need to provide the tenancy details for your instance. Tenancy details for the instance are available on the Oracle Cloud Infrastructure console. However, if you are connected to the database, you can now obtain these details by querying the CLOUD_IDENTITY column of the V$PDBS view. For example:

SELECT cloud_identity
FROM v$pdbs;

...will generate something similar to the following:

{"DATABASE_NAME" : "DBxxxxxxxxxxxx",
"REGION" : "us-phoenix-1",
"COMPARTMENT_OCID" : "ocid1.tenancy.region1..ID3"}



DOC: Obtain tenancy details for ADW to File a Service Request, click here.

DOC: Obtain tenancy details for ATP to File a Service Request, click here.



Video icon

NEW - Collateral For Autonomous Database

TRAINING: Autonomous Database Workshops on GitHub
1) Autonomous Database Quickstart - Learn about Autonomous Database on Shared Infrastructure and learn how to create an instance in just a few clicks. To run the workshop click here.
2) Analyzing Your Data with Autonomous Database - Connect using secure wallets, monitor your instance, use Analytics Desktop to visualize data and then use machine learning to try your hand at predictive analytics. To run the workshop click here.

VIDEO: Oracle Analytics Channel - Oracle Autonomous Database Experience
George Lumpkin discusses getting value from an analytics system and leveraging end-to-end solutions in an ever-changing market. To watch the video click here.

VIDEO: Using ATP as a JSON Document Store
This video demonstrates how to use ATP as a JSON document store. The video is divided into the following sections: Overview, Accessing JSON collections using a document-store API, querying JSON collections using SQL, loading JSON from object storage and viewing and analyzing data from JSON collections using a notebook. To watch the video click here.





EVENT - Global Leaders EMEA 2020 Online Summit: June 23 - June 24

Global Leaders EMEA Online Summit - June 23-24

For June the Oracle Global Leaders program is going online, with the goal of keeping you connected with your peers so you can hear the latest Oracle customer and product stories. Gain from valuable real life experience on projects with Autonomous Database, data warehousing, big data, analytics and Oracle Cloud Infrastructure.

The focus for this live online event will be a series of customer panels based on the following topics:

  • Oracle Cloud Infrastructure
  • Oracle Autonomous Database
  • Oracle Exadata for Analytics
  • Oracle Analytics
  • Oracle Machine Learning
  • Oracle Database Development

To register for this event, click here and to view the agenda, click here. If you have any questions, email Reiner Zimmermann

In association with intel®

Global Leaders Zoom Webcast - June 30
WEBCAST: The MineSense Story: Smart Shovelling with ADW and APEX - June 30

Hear how Oracle Autonomous Data Warehouse + APEX is powering smart and efficient Mining and enabling the “Scale Up” of startup company MineSense. Learn how MineSense reduced implementation time from weeks or months to days, experienced over 2x performance improvement and implemented a secure, scalable infrastructure.

To register for this Zoom webinar, 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.