X

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

Autonomous Database Newsletter - June 24 2020

Keith Laker
Senior Principal Product Manager
 

Autonomous Database
on Shared Exadata Infrastructure
June 24, 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.

 
ADB Support for ORC files

(Shared
Infrastructure
Only)


NEW - ADB now supports ORC files

ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files.

The Optimized Row Columnar (ORC) file is a highly efficient way to store Hive data. It was designed to overcome limitations of the other Hive file formats. Like Parquet, ORC data is stored in a compressed columnar format and provides metadata to enable efficient reads.

ORC, Parquet and Avro file types provide the ability to capture fields containing complex data types, including arrays, maps, unions and objects (or structs). These complex types can now be queried in ADB using Oracle’s extensive JSON query support.

Note: support for ORC and complex data types are only available in 19c.

 
LEARN MORE

DOC: DBMS_CLOUD Package ORC to Oracle Data Type Mapping for ADW, click here.

DOC: DBMS_CLOUD Package ORC, Parquet and Avro Complex Types for ADW, click here.

DOC: DBMS_CLOUD Package ORC, Parquet and Avro to Oracle Column Name Mapping for ADW, click here.

DOC: DBMS_CLOUD Package ORC to Oracle Data Type Mapping for ATP, click here.

DOC: DBMS_CLOUD Package ORC, Parquet and Avro Complex Types for ATP, click here.

DOC: DBMS_CLOUD Package ORC, Parquet and Avro to Oracle Column Name Mapping for ATP, click here.

 

 

DO MORE

 

BLOG: Query ORC files and complex data types in Object Storage with Autonomous Database, click here.

BLOG: Autonomous Database - Access Parquet Files in Object Stores, click here.


 
 

BACK TO TOP
 

(Shared
Infrastructure
Only)


NOTE - Customer Announcement About Automatic Upgrade to 19c

An email announcement about the automatic upgrade to Database 19c has been sent to ADB customers (see below). The automatic upgrade of Autonomous Databases will start in September.

At the date of the scheduled upgrade, Autonomous Database instances will be automatically upgraded in-place to Oracle Database 19c.

Please note that to better manage the customer experience during this upgrade process we are recommending that customers contact support by logging a service request if they have any questions about the upgrade process.


Email message for Autonomous Database automatic upgrade to 19c

To view the options for manually upgrading an exsting ADW instance to Database 19c - click here.

To view the options for manually upgrading an exsting ATP instance to Database 19c - click here.


 
 

BACK TO TOP
 
Icon for AWR Reports on Performance Hub

(Shared
Infrastructure
Only)


NEW - Download AWR Reports From Performance Hub

Automatic Workload Repository (AWR) report is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engineers.

Performance Hub on the OCI console now allows customers to download an AWR report for a specific time period.


AWR Reports now available via Performance Hub
 
LEARN MORE

 

DOC: Using Performance Hub to Analyze Database Performance, click here.

DOC: Active Session History Reports, click here.


 
 
DO MORE

 

DOC: Interpreting Results from Active Session History Reports...
After generating an ASH report, you can use the following sections to review its contents to help identify possible causes of transient performance problems:

  • Top Events
  • Top SQL
  • Top PL/SQL
  • Top Sessions
  • Activity Over Time

click here.

 

BACK TO TOP
 
Icon for file size increaed when transferring files to OCI Object Store

(Shared
Infrastructure
Only)


UPDATE - Maximum File Size Increased For Transfer Object Store

The maximum file size limit for DBMS_CLOUD.PUT_OBJECT procedure when transferring files to OCI Object Storage has been increased to 50 GB.

Note - there are different size restrictions when using other object stores such as Amazon S3 and Microsoft's Azure Blob Storage. See doc links below for more details.

 
LEARN MORE

 

DOC: Details of PUT_OBJECT procedure for ADW, click here.

DOC: Details of PUT_OBJECT procedure for ATP, click here.

 

 

BACK TO TOP
 
ADB Support for ORC files

(Shared
Infrastructure
Only)


UPDATE - Procedures For Using Database Real Application Security With ADB

Real Application Security works the same on Autonomous Database as on an on-premise database except you need to perform some additional administrator tasks before using Real Application Security on Autonomous Database. These tasks are now detailed in the documentation.

 
LEARN MORE

 

DOC: Procedures for using Oracle Database Real Application Security with ADW, click here.

DOC: Procedures for using Oracle Database Real Application Security with ATP, click here.

 

 

BACK TO TOP
 
ADB Support for ORC files

(Shared
Infrastructure
Only)


UPDATE - Reference Architecture Patterns and Solution Playbooks Now Available

The Architecture Center has been updated to include a new series of data warehouse patterns:

Reference Architecture Home Page

Each reference architecture pattern will come with the following: best practices framework; a set of recommendations which are a starting point for implementing the pattern and a terraform script for deploying the end-to-end set of cloud services on OCI.

Currently, the following patterns are available (note: more patterns are being built and will be added shortly):


 
 

BACK TO TOP
 
oracle.com Icon

oracle.com

ADW ATP
Documentation Icon

Documentation

ADW ATP
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

ADW ATP
 
 
 

BACK TO TOP
 

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.