Oracle® Cloud

What's New for Oracle Autonomous Data Warehouse

E87682-41

November 2019

What’s New for Autonomous Data Warehouse

Describes the Autonomous Data Warehouse features.

Here’s a summary of the Autonomous Data Warehouse additions and enhancements in this release.

Feature Description

Autonomous Data Warehouse Features

For an introduction to the features of Autonomous Data Warehouse, see About Autonomous Data Warehouse.

Database Limitations

For information on database limitations, see Autonomous Data Warehouse for Experienced Oracle Database Users.

November 2019

Feature Description
Use ACLs to specify Oracle Cloud Infrastructure VCNs

Use ACLs to specify Oracle Cloud Infrastructure VCNs that can connect to your Autonomous Database.

See Use an Access Control List with Autonomous Database for more information.

SQL Developer Web Data Loading

In SQL Developer Web in the Worksheet page, you can upload data from local files into an existing table.

See Load Data from Local Files with SQL Developer Web for more information.

Access APEX from Oracle Cloud Infrastructure Console

The Tools Tab provides access to APEX from Oracle Cloud Infrastructure Console.

See Access Oracle Application Express Administration Services for more information.

Access SQL Developer Web from Oracle Cloud Infrastructure Console The Tools Tab provides access to SQL Developer Web from Oracle Cloud Infrastructure Console.

See Access SQL Developer Web as ADMIN for more information.

Access Oracle Machine Learning from Oracle Cloud Infrastructure Console The Tools Tab provides access to Oracle Machine Learning from Oracle Cloud Infrastructure Console.

See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for more information.

View Maintenance Schedule from Oracle Cloud Infrastructure Console The Autonomous Database Information tab shows the schedule for upcoming maintenance.

See About Autonomous Database Maintenance Windows for more information.

New fields with LIST_FILES and LIST_OBJECTS The functions DBMS_CLOUD.LIST_FILES and DBMS_CLOUD.LIST_OBJECTS produce additional metadata for files and objects.

See LIST_FILES Function and LIST_OBJECTS Function for more information.

October 2019

Feature Description
Preview Version for Autonomous Database

Oracle periodically provides a preview version of Autonomous Database that allows you to test your applications and to become familiar with features in the next release of Autonomous Database.

See Preview Versions for Autonomous Database for more information.

Download database specific instance wallets or regional wallets

You can download database specific instance wallets or regional wallets.

See Download Client Credentials (Wallets) for more information.

Rotate database specific instance wallets or regional wallets

You can rotate database specific instance wallets or regional wallets.

See Rotate Wallets for Autonomous Database for more information.

Create partitioned external tables with DBMS_CLOUD

You can create and validate external partitioned tables with the DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE statements.

See Query External Partitioned Data for more information.

Numeric Formats

With the numberformat and numericcharacters format options Autonomous Database supports formats to interpret numeric strings correctly.

See DBMS_CLOUD Package Format Options for more information.

September 2019

Feature Description
Always Free Autonomous Database

You have the option to create a limited number of Always Free Autonomous Databases that do not consume cloud credits. Always Free databases can be created in Oracle Cloud Infrastructure accounts that are in a trial period, have paying status, or are always free.

See Always Free Autonomous Database for more information.

Autonomous Database Metrics

You can monitor the health, capacity, and performance of your Autonomous Data Warehouse databases with metrics, alarms, and, notifications. You can use Oracle Cloud Infrastructure console or Monitoring APIs to view metrics.

See Monitor Performance with Autonomous Database Metrics for more information.

Object Store Using Public URL

If your source files reside on an Object Store that provides public URLs, you can use public URLs with DBMS_CLOUD procedures. Public means the Object Storage service supports anonymous, unauthenticated access to the Object Store files.

See URI Format Using Public URL for more information.

Work Requests

Work Requests are available in the Oracle Cloud Infrastructure console. Work Requests let you track progress of database lifecycle management operations such as creating, terminating, backing up (manual), restoring, scaling, and cloning an Autonomous Database. Work requests allow you to track the progress and steps completed in a database operation.

See About Work Requests for more information.

August 2019

Feature Description
Create Directory and Drop Directory commands

The data_pump_dir directory is available in an Autonomous Data Warehouse database. You can use CREATE DIRECTORY to create additional directories. To drop a directory, you can use the DROP DIRECTORY command.

See Creating and Managing Directories for more information.

July 2019

Feature Description
Performance Hub

Oracle Cloud Infrastructure console includes Performance Hub for Autonomous Data Warehouse. You can view real-time and historical performance data from the Performance Hub.

See Monitor Autonomous Data Warehouse with Performance Hub for more information.

Oracle Cloud Infrastructure Native Object Store Authentication

Autonomous Data Warehouse supports native authentication with Oracle Cloud Infrastructure Object Store. Using native authentication you can use key based authentication to access the Object Store (instead of using a username and password).

See CREATE_CREDENTIAL Procedure for more information.

Move to a different Compartment

You can move an Autonomous Data Warehouse database to a different Oracle Cloud Infrastructure compartment.

See Move an Autonomous Data Warehouse Database to a Different Compartment for more information.

June 2019

Feature Description
Application Express (APEX)

Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise applications with world-class features that can be deployed anywhere. Each Autonomous Data Warehouse instance includes a dedicated instance of Oracle Application Express; you can use this instance to create multiple workspaces. A workspace is a shared work area where you can build applications.

See About Oracle Application Express for more information.

SQL Developer Web

Oracle SQL Developer Web provides a provides a development environment and a data modeler interface for Autonomous Data Warehouse.

See About SQL Developer Web for more information.

Oracle REST Data Services (ORDS)

You can develop and deploy RESTful Services with native Oracle REST Data Services (ORDS) support on an Autonomous Data Warehouse database

See Developing RESTful Services in Autonomous Database for more information.

Auto Scaling

Enabling auto scaling allows an Autonomous Data Warehouse database to use up to three times more CPU and IO resources than the currently specified CPU Core Count (up to a maximum of 128 CPU cores). When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.

See Use Auto Scaling for more information.

Azure object store with Data Pump

Autonomous Data Warehouse now supports Microsoft Azure cloud storage with Oracle Data Pump.

See Import Data Using Oracle Data Pump on Autonomous Data Warehouse for more information.

May 2019

Feature Description

Support for creating database links

You can create database links with DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to access objects on another database.

See Using Database Links with Autonomous Data Warehouse for more information.

Oracle Spatial and Graph with limitations

See Restrictions for Oracle Spatial and Graph for more information.

Oracle Text with limitations

See Restrictions for Oracle Text for more information.

Oracle Cloud Infrastructure Native URI Format Supported with Oracle Data Pump

For importing data from Data Pump files using impdp, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can use the Oracle Cloud Infrastructure native URIs in addition to the Swift URIs.

See DBMS_CLOUD Package File URI Formats for more information.

Oracle Cloud Infrastructure Pre-Authenticated URI Format Supported with DBMS_CLOUD

If your source files reside on the Oracle Cloud Infrastructure Object Storage you can use the Oracle Cloud Infrastructure Pre-Authenticated URIs. When you create a pre-authenticated request, a unique URL is generated. You can use a pre-authenticated URL in any DBMS_CLOUD procedure that takes a URL to access files in the Oracle Cloud Infrastructure object store, without the need to create a credential.

See DBMS_CLOUD Package File URI Formats for more information.

Oracle XML DB with limitations

Oracle XML DB is a high-performance, native XML storage and retrieval technology that is delivered as a part of Oracle Database. Limitations apply to Oracle XML DB with Autonomous Data Warehouse database.

See Restrictions for Oracle XML DB for more information.

Oracle Management Cloud support

Oracle Management Cloud allows you to monitor your Autonomous Data Warehouse database availability and performance.

See Using Oracle Database Management for Autonomous Databases for more information.

Modify CPU/IO Shares from Service Console

Autonomous Data Warehouse comes with predefined CPU/IO shares assigned to different consumer groups. You can modify predefined CPU/IO shares if your workload requires different CPU/IO resource allocations.You can change CPU/IO shares from the Service Console or using a PL/SQL package.

See Manage CPU/IO Shares on Autonomous Data Warehouse for more information.

April 2019

Feature Description

Support for Network Access Control Lists

Autonomous Data Warehouse now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous Data Warehouse database. When you set a network ACL the database only accepts connections from addresses specified on the ACL and rejects all other client connections.

See Set Access Control List with Autonomous Data Warehouse for more information.

Support for Updating License Type

You can now update your license type from the Oracle Cloud Infrastructure console Actions list.

See Update License Type with Autonomous Data Warehouse for more information.

Access Avro files in Object Stores

Autonomous Data Warehouse allows you to directly query and load data stored as Apache Avro format files (Apache Parquet format files are also supported). You can create external tables for Parquet or Avro format data files.

See DBMS_CLOUD Package Format Options for Parquet and Avro and CREATE_EXTERNAL_TABLE Procedure for Parquet or Avro Files for more information.

Enhanced newline handling for file record delimiter with DBMS_CLOUD

Now, when reading a file, by default DBMS_CLOUD tries to automatically find the correct newline character to use as the record delimiter, either for Windows, newline character "\r\n", or for UNIX/Linux newline character "\n". If DBMS_CLOUD finds one of these it sets the record delimiter for the file. You can specify the record delimiter explicitly if you want to override the default behavior.

See DBMS_CLOUD Package Format Options for more information.

Modify CPU/IO Shares

Autonomous Data Warehouse comes with predefined CPU/IO shares assigned to different consumer groups. You can modify these predefined CPU/IO shares if your workload requires different CPU/IO resource allocations.

See Manage CPU/IO Shares on Autonomous Data Warehouse for more information.

March 2019

Feature Description
Clone Your Database

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata.

See Cloning a Database with Autonomous Data Warehouse for more information.

Oracle Cloud Infrastructure Native URI Format Supported with DBMS_CLOUD If your source files reside on the Oracle Cloud Infrastructure Object Storage you can use the Oracle Cloud Infrastructure native URIs in addition to the Swift URIs.

See DBMS_CLOUD Package File URI Formats for more information.

UI/API Unification and Workload Type field

Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing are converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases. There is a new Workload Type field on the console showing values of either “Transaction Processing” or “Data Warehouse”, depending on the type of database you are viewing. You can also select a Workload Type when you provision an Autonomous Database.

See Workload Types for more information.

Service Gateway

You can now set up a Service Gateway with Autonomous Data Warehouse. A service gateway allows connectivity to Autonomous Data Warehouse from private IP addresses in private subnets without requiring an Internet Gateway in your VCN.

See Access Autonomous Data Warehouse with Service Gateway and Access to Oracle Services: Service Gateway for more information.

Documentation changes

The procedure DBMS_CLOUD.DELETE_ALL_OPERATIONS is now documented.

See DELETE_ALL_OPERATIONS Procedure for more information.

February 2019

Feature Description

Application Continuity

You can now enable and disable Application Continuity. Application Continuity masks outages from end users and applications by recovering the in-flight work for impacted database sessions following outages. Application Continuity performs this recovery beneath the application so that the outage appears to the application as a slightly delayed execution.

See Enabling and Disabling Application Continuity for more information.

Documentation changes

Autonomous Data Warehouse documentation includes a new chapter that describes moving data to other Oracle databases. See Moving Data from Autonomous Data Warehouse to Other Oracle Databases for more information.

January 2019

Feature Description

Access Parquet files in Object Stores

Autonomous Data Warehouse allows you to directly query and load data stored as parquet files in object stores. You can also create external parquet format tables in object stores. See COPY_DATA Procedure for Parquet Files and CREATE_EXTERNAL_TABLE Procedure for Parquet Files for more information.

October 2018

Feature Description

Oracle Cloud Infrastructure Console changes

The Autonomous Data Warehouse console has a new layout and provides new buttons that improve the usability of Autonomous Data Warehouse. These changes include a new DB Connection button that makes it easier to download client credentials.

Documentation changes The documentation page for Autonomous Data Warehouse, Getting Started includes new role based topic links.

September 2018

Feature Description

Table compression methods

In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous Data Warehouse. For more information, see Managing DML Performance and Compression.

Partitioned tables, indexes, and materialized views

Autonomous Data Warehouse now allows users to create partitioned tables, indexes, and materialized views. For more information, see Managing Partitions, Indexes, and Materialized Views.

Idle timeout changes

The idle timeout of 60 minutes is now lifted. Idle sessions that do not hold resources required by other sessions will not be terminated after 60 minutes now. For more information, see Managing Concurrency and Priorities on Autonomous Data Warehouse.

August 2018

Feature Description

The Oracle Cloud Infrastructure page has a new option Autonomous Transaction Processing

The sign in for Oracle Cloud Infrastructure now lists the new product, Oracle Autonomous Transaction Processing, in addition to Oracle Autonomous Data Warehouse.

July 2018

Feature Description

SQL Developer 18.2.0 and later without Keystore Password field for connections

When you connect to Autonomous Data Warehouse with SQL Developer 18.2.0 or later, you do not need to supply a keystore password. The keystore pasword was required in previous SQL Developer versions.

June 2018

Feature Description

New management interfaces

Autonomous Data Warehouse is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Data Warehouse instances easier with additional capabilities including sorting and filtering.

For more information, see Oracle Help Center.

Better authorization management

With OCI Identity and Access Management (IAM) you can better organize and isolate your Autonomous Data Warehouse instances using Compartments and control what type of access a user or group of users have.

Built-in auditing

The OCI Audit service records use of Autonomous Data Warehouse application programming interface (API) endpoints as log events in JSON format. You can view, copy, and analyze audit events with standard log analysis tools or using the Audit service Console, the Audit APIs, or the Java SDK.

Availability of the Phoenix region

Autonomous Data Warehouse is now available in the Phoenix region in addition to Ashburn and Frankfurt regions.

User Assistance changes

The documentation, videos, and examples are updated on the Oracle Help Center to include the procedures to create and control Autonomous Data Warehouse instances with the Oracle Cloud Infrastructure Console.

A new Related Resources page shows related resources including the Autonomous Data Warehouse Forum .

Idle timeouts in database services

The idle timeouts for three database services, high, medium, and low, have now been relaxed. The previous idle timeout setting of 5 minutes will now apply to only idle sessions that hold resources needed by other active users. See Managing Concurrency and Priorities on Autonomous Data Warehouse.

May 2018

Feature Description

Oracle Cloud Infrastructure Object Storage Credentials

The name Swift Password is now Auth token. Use of Swift password in the documentation is now replaced with Auth token.

April 2018

Feature Description

Microsoft Azure Blob Storage integration

Autonomous Data Warehouse now supports Microsoft Azure Blob Storage for data loading and querying external data. You can load data from or run queries on files residing on Azure Blob Storage. See Loading Data from Files in the Cloud.

Manage files on the local file system

You can now list files residing on the local file system on Autonomous Data Warehouse, see LIST_FILES Function.

You can also remove files from the local file system. See DELETE_FILE Procedure.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle Cloud What's New for Oracle Autonomous Data Warehouse

E87682-41

Copyright © 2018, 2019, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.