What’s New for Oracle Autonomous Database on Shared Exadata Infrastructure

Here’s a summary of the noteworthy Oracle Autonomous Database additions and enhancements.

March 2021

Feature Description

Oracle Machine Learning for Python (OML4Py)

Oracle Machine Learning for Python (OML4Py) on Autonomous Database provides a Python API to explore and prepare data, and build and deploy machine learning models using the database as a high-performance compute engine. OML4Py is available through the Python interpreter in Oracle Machine Learning Notebooks.

See Get Started with Notebooks for Data Analysis and Data Visualization for more information.

February 2021

Feature Description

Oracle Database Actions

SQL Developer Web is now called Database Actions. Database Actions is a web-based interface that provides development tools, data tools, administration, and monitoring features for Autonomous Database. Using Database Actions you can load data and run SQL statements, queries, and scripts in a worksheet.

See Connect with Built-in Oracle Database Actions for more information.

Query Big Data Service Hadoop (HDFS) Data

Big Data Service provides enterprise-grade Hadoop as a service, with end-to-end security, high performance, and ease of management and upgradeability. After deploying the Oracle Cloud SQL Query Server to Big Data Service, you can easily query data available on Hadoop clusters at scale from Autonomous Database using SQL.

See Query Big Data Service Hadoop (HDFS) Data from Autonomous Database for more information.

January 2021

Feature Description

Autonomous Database Events

Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. There are two new Information events: ScheduledMaintenanceWarning and WalletExpirationWarning.

See Use Autonomous Database Events for more information.

Manual Backup Enhancements

You can choose the bucket name to store manual backups and the steps to configure manual backups are simplified.

See Manual Backups on Autonomous Database for more information.

Private Endpoint Support for Tools (Oracle Machine Learning Notebooks are supported with Private Endpoints)

You can access Oracle Application Express, Oracle SQL Developer Web, Oracle REST Data Services, and Oracle Machine Learning Notebooks with Private Endpoints.

See Configuring Network Access with Private Endpoints for more information.

2020 What's New

December 2020

Feature Description

Replicate Data and Capture Data with Oracle GoldenGate

Using Oracle GoldenGate you can capture changes from an Oracle Autonomous Database and replicate to any target database or platform that Oracle GoldenGate supports, including another Oracle Autonomous Database.

See Oracle GoldenGate Capture for Oracle Autonomous Database for more information.

Oracle APEX Application Development

Oracle APEX Application Development (APEX Service) is a low cost Oracle Cloud service offering convenient access to the Oracle Application Express platform for rapidly building and deploying low-code applications.

See Oracle APEX Application Development for more information.

Oracle Database 21c with Always Free Autonomous Database

Oracle Database 21c is available with Always Free Autonomous Database. See the following for more information:

Oracle APEX 20.2

Autonomous Database uses Oracle Application Express 20.2.

See Creating Applications with Oracle Application Express in Autonomous Database for more information.

November 2020

Feature Description

Amazon S3 Presigned URLs

You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential.

See Amazon S3 Compatible URI Format for more information.

Azure Blob Storage Shared Access Signatures (SAS) URLs

You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential.

See Azure Blob Storage URI Format for more information.

October 2020

Feature Description

User-Defined Profiles Minimum Password Length

If you create a user-defined profile with a Password Verification Function (PVF), then the minimum password length can be 8 characters.

See Manage Password Complexity on Autonomous Database for more information.

PL/SQL SDK for Oracle Cloud Infrastructure Resources

PL/SQL SDK for Oracle Cloud Infrastructure enables you to write code to manage Oracle Cloud Infrastructure resources. The PL/SQL SDK is on all Autonomous Databases using shared Exadata infrastructure.

See PL/SQL SDK for more information.

Documentation Addition: Oracle Database Actions User Management

You can quickly create users and modify account settings for users with Oracle Database Actions.

See Create Users on Autonomous Database for more information.

Autonomous Database Events

Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. Subscribing to Autonomous Database events allows you to create automation and to receive notifications when the events occur.

See Use Autonomous Database Events for more information.

September 2020

Feature Description

Private Endpoint Support for Tools

You can access Oracle Application Express, Oracle SQL Developer Web, and Oracle REST Data Services with Private Endpoints.

See Configuring Network Access with Private Endpoints for more information.

Read-Only and Restricted Modes

You can select an Autonomous Database operation mode. The default mode is Read/Write. If you select Read-Only mode users can only run queries. In addition, for either mode you can restrict access to only allow privileged users to connect to the database.

See Change Autonomous Database Mode to Read/Write or Read-Only for more information.

Refreshable Clones

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.

See Using Refreshable Clones with Autonomous Database for more information.

Documentation Addition: Auditing Autonomous Database

This new chapter describes the auditing features that allow you to track, monitor, and record activity on your database. Auditing can help you detect security risks and improve regulatory compliance for your database.

See Auditing Autonomous Database for more information.

August 2020

Feature Description

Autonomous JSON Database

If your database version is Oracle Database 19c or higher, you can provision an Autonomous JSON Database. Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents.

See About Autonomous JSON Database for more information.

Amazon S3-Compatible Object Stores

Autonomous Database supports Amazon S3-Compatible object stores, such as Oracle Cloud Infrastructure Object Storage, Google Cloud Storage, and Wasabi Hot Cloud Storage.

See Load Data from Files in the Cloud for more information.

Asynchronous Requests using SEND_REQUEST

The DBMS_CLOUD SEND_REQUEST function supports long running requests with the additional parameters: async_request_url, wait_for_states, and timeout.

See SEND_REQUEST Function for more information.

Rename Database

If your database version is Oracle Database 19c or higher, you can rename your Autonomous Database.

See Rename Autonomous Database for more information.

July 2020

Feature Description

Oracle Application Express Release 20.1

Autonomous Database supports Oracle Application Express Release 20.1.

See Creating Applications with Oracle Application Express in Autonomous Database for more information.

If your Autonomous Database instance is on Oracle Database 18c, to use APEX 20.1 you must upgrade to Oracle Database 19c. After you upgrade to Oracle Database 19c, APEX is automatically upgraded to APEX 20.1.

Use a Standby Database

Autonomous Database provides the Autonomous Data Guard feature to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance.

See Using a Standby Database with Autonomous Database for more information.

Create and Alter User Profiles

You can create and alter database user profiles.

See Manage User Profiles with Autonomous Database for more information.

Manage Time Zone File Versions

The time zone files are periodically updated to reflect the latest time zone specific changes. Autonomous Database automatically picks up the updated time zone files.

See Manage Time Zone File Version on Autonomous Database for more information.

Network Access Changes

If your Autonomous Database network access is configured to use a private endpoint you can change the configuration to use a public endpoint. Likewise, if your Autonomous Database instance is configured to use a public endpoint, you can change the configuration to use a private endpoint.

Autonomous Database network access changes from a public to a private endpoint, or from a private to a public endpoint are only supported with database versions Oracle Database 19c onwards.

See Configuring Network Access with Access Control Rules (ACLs) and Private Endpoints for more information.

Use Database Links to Access Non-Oracle Databases

You can create database links from an Autonomous Database to an Oracle Database Gateway to access Non-Oracle databases.

See Create Database Links to an Oracle Database Gateway to Access Non-Oracle Databases for more information.

June 2020

Feature Description

ORC Format and Complex Types

Autonomous Database supports loading and querying data in object store in ORC format, in addition to Avro and Parquet. Also, for ORC, Avro, and Parquet structured file types you can load and query complex data types. Support for ORC format and complex types requires Oracle Database 19c.

See Load Data from Files in the Cloud and Query External Data with ORC, Parquet, or Avro Source Files for more information.

PUT_OBJECT Maximum File Transfer Size Increase

The DBMS_CLOUD.PUT_OBJECT procedure maximum size limit for file transfers to Oracle Cloud Infrastructure Object Storage is increased to 50 GB.

See PUT_OBJECT Procedure for more information.

Customer Managed Oracle REST Data Services

You can use a customer managed environment to run Oracle REST Data Services (ORDS) if you want to control the configuration and management of ORDS. Installing and configuring a customer managed environment for ORDS allows you to run ORDS with configuration options that are not possible using the default Oracle managed ORDS available with Autonomous Database.

See About Customer Managed Oracle REST Data Services on Autonomous Database for more information.

May 2020

Feature Description

Move Selective Data to Object Store

You can export data to Oracle Data Pump dump files on Object Store by specifying a query to select the data to export.

See Move Selective Data to Object Store Using DBMS_CLOUD.EXPORT_DATA for more information.

Obtain Tenancy Details for a Service Request

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 or you can obtain these details by querying the database.

See Obtain Tenancy Details to File a Service Request for more information.

Upgrade Autonomous Database to Oracle Database 19c

If your Autonomous Database instance is on Oracle Database 18c, you can upgrade to Oracle Database 19c by clicking Upgrade to 19c.

April 2020

Feature Description
SODA Documents and Collections

Autonomous Database supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows you to store, search, and retrieve document collections, typically JSON documents, without using SQL. You can also access document collections with SQL/JSON operators, providing you with the simplicity of a document database but with the power of a relational database.

See Using JSON Documents with Autonomous Database for more information.

Load Data with Oracle Data Pump Access Driver Dump Files

You can use Oracle Data Pump dump files in the Cloud as source files to load your data. The files for this load type must be exported from the source system using the ORACLE_DATAPUMP access driver in External Tables.

See Create Credentials and Load Data Pump Dump Files into an Existing Table for more information.

Create External Tables and Query Data with Oracle Data Pump Access Driver Dump Files

You can query Oracle Data Pump dump files in the Cloud by creating an external table. The source files to create this type of external table must be exported from the source system using the ORACLE_DATAPUMP access driver in External Tables.

See Query External Data Pump Dump Files for more information.

Oracle Extensions for IDEs

You can use Oracle extensions for IDEs to develop applications on Autonomous Database. Extensions are available for Eclipse, Microsoft Visual Studio, and Microsoft Visual Studio Code (VS Code). These extensions enable you to connect to, browse, and manage Autonomous Databases in Oracle Cloud directly from the IDE.

See Use Oracle Extensions for IDEs to Develop Applications for more information.

Per-Second Billing

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

Stateful Rule Support in Private Endpoints

When you configure a private endpoint you define a security rule(s) in a Network Security Group (NSG); this creates a virtual firewall for your Autonomous Database and allows connections to the Autonomous Database instance. The NSG can now be configured with stateful rules.

See Configure Private Endpoints with Autonomous Database for more information.

Wallet zip File Contains README File

The wallet file that contains client credentials (wallet files) for your Autonomous Database instance now also has a README file with wallet expiration information. Wallet files that were downloaded prior to April 2020 do not contain this file.

See Download Client Credentials (Wallets) for more information.

March 2020

Feature Description

Restart Autonomous Database instance

Use Restart to restart an Autonomous Database instance.

See Restart Autonomous Database for more information.

Oracle Data Pump Direct Export to Object Store

Depending on your cloud object store, you can use Oracle Data Pump to directly export to your object store to move data between Autonomous Database and other Oracle databases.

See Move Data with Data Pump Export to Object Store for more information.

Oracle Data Pump Pre-authenticated URLs for Dump Files

If your source files reside on Oracle Cloud Infrastructure Object Storage, you can use pre-authenticated URLs with Oracle Data Pump.

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

Documentation Addition: Upgrade Autonomous Database to Oracle Database 19c

Provides information on upgrading to Oracle Database 19c if your Autonomous Database instance is on Oracle Database 18c.

Oracle Database Versions by Region

Depending on the region where you provision or clone your database, Autonomous Database supports one or more Oracle Database versions. Oracle Database 19c is available in all commercial regions.

Oracle Application Express Release 19.2

Autonomous Database supports Oracle Application Express Release 19.2.

See Creating Applications with Oracle Application Express in Autonomous Database for more information.

February 2020

Feature Description

Private Endpoints

This configuration option assigns a private endpoint, private IP and hostname, to a database and allows traffic only from the VCN you specify; access to the database from all public IPs or VCNs is blocked. This allows you to define security rules at the Network Security Group (NSG) level and to control traffic to your Autonomous Database.

See About Network Access Options for more information.

Oracle Database Vault

Oracle Database Vault implements powerful security controls for your database. These unique security controls restrict access to application data by privileged database users, reducing the risk of insider and outside threats and addressing common compliance requirements.

See Using Oracle Database Vault with Autonomous Database for more information.

Oracle Application Express Release 19.2

If your database instance is an Always Free Autonomous Database or is a database with Oracle Database release 19c, then your database has Oracle Application Express Release 19.2.

See Creating Applications with Oracle Application Express in Autonomous Database for more information.

Database Resident Connection Pool (DRCP)

Using DRCP provides you with access to a connection pool in your database that enables a significant reduction in key database resources required to support many client connections.

See Use Database Resident Connection Pooling with Autonomous Database for more information.

January 2020

Feature Description

Clone from a backup

Clone from a backup lets you create a clone by selecting a backup from a list of backups, or with a timestamp for a point-in-time to clone.

See Clone Autonomous Database from a Backup for more information.

Check and set MAX_STRING_SIZE value

By default the database uses extended data types and the value of MAX_STRING_SIZE is set to the value EXTENDED. To support migration from older Oracle Databases or applications you can set MAX_STRING_SIZE to the value STANDARD.

See Checking and Setting MAX_STRING_SIZE for more information.

Number of concurrent statements increased depending on the service you use

The maximum number of concurrent statements is increased, depending on the connection service you are using.

See Predefined Database Service Names for Autonomous Database for more information.

Documentation addition showing available Oracle Database versions

The documentation shows the Oracle Database version available with Autonomous Database by region.

See Oracle Database Version Availability by Region for more information.

DBMS_CLOUD REST API functions

The DBMS_CLOUD REST API functions allow you to make HTTP requests using DBMS_CLOUD.SEND_REQUEST. These functions provide a generic API that lets you call REST APIs from supported cloud services.

See DBMS_CLOUD REST APIs for more information.

Documentation addition to describe sending mail with UTL_SMTP

The documentation is updated to provide the steps and sample code for sending email using UTL_SMTP.

See Sending Mail with Email Delivery on Autonomous Database for more information.

Use ACLs to control access for Autonomous Database tools

You can now use Virtual Cloud Network, Virtual Cloud Network (OCID), IP address, or CIDR block ACLs to control access to Oracle Application Express (APEX), RESTful services, and SQL Developer Web.

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

2019 What's New

December 2019

Feature Description
Support for UTL_HTTP and UTL_SMTP PL/SQL Packages with restrictions

Autonomous Database supports the Oracle Database PL/SQL packages UTL_HTTP, UTL_SMTP, and DBMS_NETWORK_ACL_ADMIN with restrictions.

See Restrictions for Database PL/SQL Packages for more information.

Microsoft Active Directory Users

You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. This allows Active Directory users to access a database using their Active Directory credentials.

See Use Microsoft Active Directory with Autonomous Database for more information.

Validate external partitioned tables and hybrid partitioned tables

You can validate individual partitions of an external partitioned table or a hybrid partitioned table with the procedures DBMS_CLOUD.VALIDATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_HYBRID_PART_TABLE.

See Validate External Partitioned Data and Validate Hybrid Partitioned Data for more information.

Use ACL IP address or CIDR block settings to control access for Autonomous Database tools

You can now use IP address and CIDR based ACLs to control access to Oracle Application Express (APEX), RESTful services, and SQL Developer Web.

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

Use Oracle Data Safe

Oracle Data Safe provides features that help you protect sensitive and regulated data in your database.

See Safeguard Your Data with Data Safe on Autonomous Database for more information.

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.

SQL Developer Web Data Loading

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

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 User Administration from Oracle Cloud Infrastructure Console.
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 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 a 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 Database. You can view real-time and historical performance data from the Performance Hub.

See Monitor Autonomous Database with Performance Hub for more information.

Oracle Cloud Infrastructure Native Object Store Authentication

Autonomous Database 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 a database to a different Oracle Cloud Infrastructure compartment.

See Move an Autonomous 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 Database 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 Database.

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 a database

See Developing RESTful Services in Autonomous Database for more information.

Auto Scaling

Enabling auto scaling allows a database to use up to three times more CPU and IO resources than the currently specified CPU Core Count. 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.

Azure object store with Data Pump

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

See Import Data Using Oracle Data Pump on Autonomous Database 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 Use Database Links with Autonomous Database 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 Database database.

See Restrictions for Oracle XML DB for more information.

Oracle Management Cloud support

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

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

Modify CPU/IO Shares from Service Console

Autonomous Database 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 Database for more information.

April 2019

Feature Description

Support for Network Access Control Lists

Autonomous Database now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous Database 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 Configuring Network Access with Access Control Rules (ACLs) 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 on Autonomous Database for more information.

Access Avro files in Object Stores

Autonomous Database 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 Database 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 Database for more information.

March 2019

Feature Description
Clone Your Database

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

See Cloning a Database with Autonomous Database 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 Database. A service gateway allows connectivity to Autonomous Database from private IP addresses in private subnets without requiring an Internet Gateway in your VCN.

See Access Autonomous Database 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 Database documentation includes a new chapter that describes moving data to other Oracle databases. See Moving Data from Autonomous Database to Other Oracle Databases for more information.

January 2019

Feature Description

Access Parquet files in Object Stores

Autonomous Database 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.

2018 What's New

October 2018

Feature Description

Oracle Cloud Infrastructure Console changes

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

September 2018

Feature Description

Table compression methods

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

Partitioned tables, indexes, and materialized views

Autonomous Database 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 Manage Concurrency and Priorities on Autonomous Database.

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 Database.

July 2018

Feature Description

SQL Developer 18.2.0 and later without Keystore Password field for connections

When you connect to Autonomous Database 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 Database is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous Database 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 Database 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 Database 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 Database 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 Database 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 Manage Concurrency and Priorities on Autonomous Database.

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 Database 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 Database, 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.