No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
What's New in Autonomous Database

What's New in Autonomous Database

Oracle Autonomous Database is Oracle's new, fully managed database tuned and optimized for both data warehouse and transaction processing workloads with the market-leading performance of Oracle Database. It delivers a completely new, comprehensive cloud experience for data warehousing and transaction processing workloads that is easy, fast, and elastic.

This page lists the new features and updates added to Autonomous Database.

Last Updated July 15, 2020.

July 2020

Creating a standby database with Autonomous Data Guard

(Shared Infrastructure Only)

 

When you enable Autonomous Data Guard on ADB, the system creates a standby database that stays "connected" to the primary database and automatically refreshes its data from the primary database.

This allows the following, depending on the state of the primary database:

If your primary database goes down, Autonomous Data Guard converts the standby database to the primary database with minimal interruption. After failover completes, Autonomous Data Guard automatically creates a new standby database.

You can perform a switchover operation, where the primary database becomes the standby database, and the standby database becomes the primary database.

Note: Autonomous Database does not provide access to the standby database.

Simplified animated GIF showing creation of an Autonomous Data Guard standby instance for ADW

Simplified animation showing basic steps to create an ADG standby instance for ADW


 

Using OCI Resource Manager to Deploy Data Warehouse Reference Architecture Patterns

(Shared Infrastructure Only)

 

The list of pre-built Stacks within OCI Resource Manager has been expanded to include some of the new reference architecture patterns that support this our Modern Data Warehouse strategy. Currently, the Departmental Data Warehouse pattern is available as a pre-built stack and the other Modern Data Warehouse patterns will be available shortly.

Simplified animated GIF showing automated deployment process for reference architecture patterns
 

Simplified animation showing basic steps for using Resource Manager pre-built stacks to deploy a departmental data warehouse.


 

Connecting to Non-Oracle Databases

(Shared Infrastructure Only)

 

Autonomous Database now supports using connections that are enabled via Oracle Database Gateway. Gateways are designed for accessing a specific non-Oracle Database such as DB2, Teradata, SQL Server etc.

Oracle Database Gateway provide queries and applications with access to data anywhere in a distributed database system without knowing either the location of the data or how it is stored. This removes the need to customize applications to access data from non-Oracle systems.


 

Modify Network Settings for ADB Instances

(Shared Infrastructure Only)

 

Autonomous Database now supports switching network access type. This feature enables customers to perform an in-place switch from public endpoint to private endpoint (and vice versa).

The feature will reduce customer effort required for switching between public and private endpoints and make it easier for customers to adopt private endpoint.

 


 

Timezone Files Automatically Updated

(Shared Infrastructure Only)

 

For time zone support, Oracle Database uses time zone files that store the list of all time zones. The time zone files for Autonomous Database are periodically updated to reflect the latest time zone specific changes.

An Autonomous Database instance will automatically pick up updated time zone files depending on the lifecycle state of the instance:

- Stopped: At the next start operation the update is automatically applied.
- Available: After a restart the update is automatically applied.

When a load or import operation results in a timezone related error, restart the ADB instance and try again.


 

Create/Modify User Profile and Set Password

(Shared Infrastructure Only)

 

Autonomous Database now supports the ability to create/alter user profiles and import existing user profiles from another environment with Oracle Data Pump Import.

Cloud Admins can now manage the rules for password complexity on Autonomous Database. Administrators can can create a Password Verify Function (PVF) and associate the PVF with a profile to manage the rules for password complexity.


 
 

June 2020

ADB now supports Customer Managed Oracle REST Data Services

(Shared Infrastructure Only)

 

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.


 

Performance Hub Now Has a Timezone Selector

(Shared Infrastructure Only)

 

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

SQL access to tenancy details for ADB

(Shared Infrastructure Only)

 

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",
"TENANT_OCID" : "OCID1.TENANCY.REGION1..ID1",
"DATABASE_OCID" : "OCID1.AUTONOMOUSDATABASE.OC1.SEA.ID2",
"COMPARTMENT_OCID" : "ocid1.tenancy.region1..ID3"}


 
 

May 2020

Workload metrics on performance Hub

(Shared Infrastructure Only)

 

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
 

Latency Metrics Now Available in Service Metrics

(Shared Infrastructure Only)

 

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
 
 

April 2020

Autonomous Database now comes with an SLA

(Shared Infrastructure Only)

 

The service level agreement for ADB has just been published and it applies only to the deployment of an Autonomous Database on shared infrastructure.

In the event an Autonomous Database Service on Shared Infrastructure does not meet the "Service Commitment" then customers will be eligible to receive Service Credits. Note - there are specific definitions of key terms in the pillar document (listed in the Learn More... link) that you should read and understand.


 

Per-Second Billing

(Shared Infrastructure Only)

 

Autonomous Database instance CPU and storage usage is now 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.

This change benefits the following types of use cases:


 

Support for SODA Documents and Collections

(Shared Infrastructure Only)

 

Autonomous Database now supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows developers to store, search, and retrieve document collections, typically JSON documents, without using SQL.

It is possible to also access document collections with SQL/JSON operators. ADB now combines the simplicity of a document database with the power of a relational database.

The Oracle Cloud Infrastructure console has been updated with a link to access the SODA drivers for several languages and frameworks including: Java, Node.js, Python, Oracle Call Interface, and PL/SQL, as shown below.

Autonomous Database tools panel on OCI console showing access to new SODA drivers



 

ADB Extensions for IDEs

(Shared Infrastructure Only)

 

Oracle extensions enable developers to connect to, browse, and manage Autonomous Databases in Oracle Cloud directly from their IDEs. There are extensions for following IDEs: Eclipse, Microsoft Visual Studio and Visual Studio Code.

Users with permissions to manage the databases can perform a number of actions (depending on their IDE), including the following:

  • Sign up for Oracle Cloud
  • Connect to a cloud account using a simple auto-generated config file and key file
  • Create new or clone existing Always Free Autonomous Database, Autonomous Database Dedicated, and Autonomous Database Shared databases
  • Automatically download credentials files (including wallets) and quickly connect, browse, and operate on Autonomous Database schemas
  • Change compartments and regions without reconnecting
  • Start, stop, or terminate Autonomous Database databases
  • Scale up/down Autonomous Database resources
  • Restore from backup
  • Update instance credentials, update the license type used
  • Rotate wallets
  • Convert Always Free Autonomous Database databases into paid databases


 

Stateful Rule Support in Private Endpoints

(Shared Infrastructure Only)

 

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



 

Enhancements Related to Data Pump

(Shared Infrastructure Only)

 

Two specific improvements relating to how Data Pump dump files can be used with ADB:

  • Can query Data Pump dump files in the Cloud by creating an external table
  • Can use Data Pump dump files in the Cloud as source files to load data


 

March 2020

Upgrade an Autonomous Database Instance to Oracle Database 19c

(Shared Infrastructure Only)

 

Oracle Database 19c is now available on Autonomous Database for all regions. In select regions, customers can choose between Oracle Database 18c and Oracle Database 19c for new databases. The default version for all new databases is 19c and during this period, most new Autonomous Database features will only be available for databases using Oracle Database 19c.

Please start planning for the upgrade of your applications to Database 19c. For most applications, there should not be any changes required. However, it is recommended you should test your applications with Database 19c. You can easily test your applications by creating a clone of your current database to Oracle Database 19c, and testing your application using this clone.

Oracle Database 18c is scheduled to be available in Autonomous Database until September, 2020.

You can choose to upgrade your database at any time during this period. After that time, all existing databases will be automatically upgraded to Oracle Database 19c. There are several approaches to upgrading your database which are described in the documentation, see "Learn More" link.

Note: Autonomous Database plans to offer a new upgrade path starting in April, with a single button that provides a one-way, in-place upgrade.




 

Data Pump Support For Pre-Authenticated URLs

(Shared Infrastructure Only)

 

This enhancement allows Oracle Data Pump to use Oracle Cloud Infrastructure pre-authenticated URIs for source files on Oracle Cloud Infrastructure Object Storage.

Note: Customers should carefully assess the business requirement for and the security ramifications of pre-authenticated access. There is more guidance available in the documentation.


 

Data Pump Export to Object Store

(Shared Infrastructure Only)

 

It is now possible for Oracle Data Pump to directly export to Oracle Object Store which simplifies the process of moving data between Autonomous Data Warehouse and other Oracle databases. This export method is supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic


 

Menu Option to Restart ADB Instance

(Shared Infrastructure Only)

 

A new menu option has been added to the OCI console to automate the process of stopping and then starting an ADB instance. The new menu option is labeled "Restart" as shown below:


 

Why is this useful?
This feature has been added to make it even easier to implement Database Vault. When you enable Database Vault (or disable it) you need to restart your ADB instance for the changes to take effect. This “restart’ feature helps to minimize downtime by avoiding the need to "stop" then "start" the ADB instance as two distinct, separate operations.

README file added to Wallet

(Shared Infrastructure Only)

 

The Oracle client credentials wallet zip file now contains a README file. This file provides information about the wallet expiry date. An example of the contents of the new readme file is shown below:

 

Wallet Expiry Date
-----------------------
This wallet was downloaded on 2020-04-03 10:19:43.4 UTC.
The SSL certificates provided in this wallet will expire on 2025-03-31 21:26:18.928 UTC.
In order to avoid any service interruptions due to an expired SSL certificate, you must re-download the wallet before this date.


 
 

February 2020

Autonomous Database Now Supports Private Endpoints

(Shared Infrastructure Only)

It is now possible to restrict access to Autonomous Database by specifying a private endpoint within a Virtual Cloud Network (VCN). Configuration of private access is done when provisioning or cloning an Autonomous Database - allowing all traffic to and from an Autonomous Database to be kept off the public internet.

During provisioning or cloning, it is possible to specify private access for an Autonomous Database by selecting Virtual cloud network within the Choose network access section of the create/clone dialog, as shown below:


ADB Logo

Description of the illustration adb_private_vcn.png

 

The configuration process for enablishing private endpoints involves three steps which must be done before provisioning or cloning an Autonomous Database:


 

Using Oracle Database Vault with Autonomous Database

(Shared Infrastructure Only)

 

Oracle Database Vault implements powerful security controls for your Autonomous 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.

 

Always Free Autonomous Database now includes APEX 19.2

(Shared Infrastructure Only)

 

Oracle APEX 19.2 on Always Free Autonomous Database provides a preconfigured, fully managed and secured environment to both build and deploy world-class data-centric applications. Oracle APEX applications developed on-premise can be easily deployed to Oracle APEX on the free version Autonomous Database.

 

Multiple Database Versions Now Supported

(Shared Infrastructure Only)

 

Depending on the region where you provision or clone your database, Autonomous Database now supports one or more Oracle Database versions. The version availability depends on the region - note that some regions do not support multiple Oracle Database versions.

When multiple database versions are available, you choose an Oracle Database version when you provision or clone a database

Multiple Database Support when creating a new ADB instance
 

Availability of Oracle Graph Server and Client 20.1

(Shared Infrastructure Only)

 

Oracle Graph Server and Client 20.1 is a software package that works with Autonomous Database. It includes the in-memory analytics server (PGX) and client libraries required to work with the Property Graph feature in Autonomous Database.

With graph analytics you can explore and discover connections and patterns in social networks, IoT, big data, data warehouses, and complex transaction data for applications such as fraud detection in banking, customer 360, and smart manufacturing.

 

Features to Simplify Migrations To ADB

(Shared Infrastructure Only)

 

1. Database Resident Connection Pool (DRCP)
Using DRCP provides you with access to a connection pool in your ADB 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.

DOC: ADW click here.
DOC: ATP click here.

 

2. Set MAX_STRING_SIZE value
By default the Autonomous Data Warehouse database uses MAX_STRING_SIZE 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.

DOC: ADW click here.
DOC: ATP click here.

 

3. Number of concurrent statements
The maximum number of concurrent statements is increased. See Predefined Database Service Names for Autonomous Data Warehouse for more information.

DOC: ADW click here.
DOC: ATP click here.

 

New Data Centers Online

(Shared Infrastructure Only)

 

Autonomous Database is now available in the following data centers:

For more information on the status of services in each data center click here. For more information about how to subscribe to these new regions, click here. To switch to the new region, use the Region menu in the Console. See Switching Regions for more information, click here.

 

January 2020

Access Control Lists Honored By ADB Built-in Tools

(Shared Infrastructure Only)

 
Learn more...

See section marked "Access Control List Notes" for more information.

ADB's built-in tools (Application Express [APEX], RESTful services, and SQL Developer Web) are now subject to ACLs to control access.

This means it is now possible to use Virtual Cloud Network, Virtual Cloud Network-OCID, IP address, or CIDR block ACLs to control access to these tools.

 

Clone from Backup

(Shared Infrastructure Only)

 

When you clone an Autonomous Database instance you now have the option to clone from an existing backup. You can select a backup from a list of backups or a point-in-time as the source for the clone.

NOTE - when an upcoming release is available for preview with Autonomous Database, you can clone your existing database or clone a backup to use the preview version.

Images below show the UI for creating a "Point in time" clone and creating a clone from a specific backup:


Point in time clone

Description of the illustration adb_clone_source_backup.png



Clone from backup

Description of the illustration adb_clone_source_list.png

For a list of restrictions that apply to the cloning process please refer to the notes section in the documentation - see links on the left.


 
 

REST APIs Added to DBMS_CLOUD

(Shared Infrastructure Only)

 

The DBMS_CLOUD REST API functions provide a generic API that lets you call any REST API with the following supported cloud services:

DBMS_CLOUD supports GET, PUT, POST, HEAD and DELETE HTTP methods. The REST API method to be used for an HTTP request is typically documented in the Cloud REST API documentation.

 

Send Emails Using ADB

(Shared Infrastructure Only)

 

Autonomous Database now includes the UTL_SMTP package. This makes it possible to send emails via PL/SQL from within Autonomous Database. However, note that the only supported email provider is Oracle Cloud Infrastructure Email Delivery service - for example:


 
 

End Of 19c Preview

(Shared Infrastructure Only)

 

The preview version of ADB 19c will now end on January 30. All resources created with this preview will be terminated at the end of the preview period. The console has been updated and now shows the end date as January 30, see below:


Updated 19c Preview banner announcement
 

Custom Maintenance Schedule

(Dedicated Infrastructure Only)

 

Autonomous Database dedicated infrastructure customers can now define separate maintenance schedule for their container databases, previously the container database maintenance schedule follows the maintenance schedule of the Autonomous Exadata Infrastructure. This feature enables users to specify patching schedules based on operational requirements, for example, patch and verify on dev/test autonomous databases before applying them on production autonomous databases.

 

December 2019

New Names For Deployment Options

 

Note that the Autonomous Data Warehouse and Autonomous Transaction Processing are subject to name changes which are now live. The new names for the deployment options are:

  • Shared Exadata Infrastructure
  • Dedicated Exadata Infrastructure

Image below shows the updated text for the deployment options when creating a new ADW instance:

Form for creating a new ADW showing new banner name for severless deployment
 

Help Center landing pads for ADW and ATP have been update to reflect the new naming as shown below for ADW:

Get Started home page within Help Center, showing new banner name for severless deployment

Get Started home page within Help Center, showing banner new name for dedicated deployment
 

ADB Maintenance Window on OCI Console

(Shared Infrastructure Only)

 

All Autonomous Database instances are automatically assigned to a maintenance window and different instances can have different maintenance windows.

On the Autonomous Database details page, the "Next Maintenance" field shows the date and time for the upcoming maintenance window. The field is updated automatically when the next maintenance window is scheduled.


New maintenance window information on ADW console

Click here for a full-screen version of above image


 

ADB now leverages Microsoft Active Directory

(Shared Infrastructure Only)

 

Autonomous Database now supports use of Microsoft Active Directory to authenticate and authorize users and roles. Active Directory users can now access an Autonomous Database using their Active Directory credentials.

This works by mapping Microsoft Active Directory users and groups to users and roles within Autonomous Database.


 

Access Control Lists and ADB Built-in Tools

(Shared Infrastructure Only)

 

ADB's built-in tools (Oracle Application Express (APEX), RESTful services, and SQL Developer Web) now honor IP address/CIDR block ACLs to control access.

Note that currently these built-in tools are not subject to Virtual Cloud Network and Virtual Cloud Network (OCID) type ACLs.


 

Partitioned External Tables now support Parquet and Avro Files

 

CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and Avro files formats.

This procedure creates an external partitioned table on files in the Cloud. This change now allows you to run queries on external data files, of type Avro and Parquet, from within Autonomous Data Warehouse.


 

New Networking QuickStart Wizard

 

The OCI network team has announced the general availability of a new Networking QuickStart wizard. The wizard can be used to quickly create a VCN with regional public and private subnets, a NAT gateway, service gateway and an internet gateway along with the necessary route table and security list rules.

The public subnet will have routes to the internet via the internet gateway. The private subnet will have routes to the internet and Oracle Services Network via the NAT gateway and service gateway, respectively. Security lists will be created with basic security rules including SSH access.

The wizard reduces the number of steps and amount of time it takes to setup your network to 1-2 minutes.

There are two ways to launch the new wizard:

  • From the Oracle Cloud Console home page, click the Quick Action for "Networking: Set up a network with a wizard".
  • In the navigation menu, under Core Infrastructure, go to Networking and click Virtual Cloud Networks, then click on Networking QuickStart


UI for new network setup wizard - option 1 defining VCN configuration


UI for new network setup wizard - option 2 defining VCN and VPN configuration
 

New Metadata Extensions within DBMS_CLOUD

 

DBMS_CLOUD has been extended with the following new subprograms:

1) LIST_FILES Function - lists the files in the specified directory. The results include the file names and additional metadata about the files such as file size in bytes, creation timestamp, and the last modification timestamp.

2) LIST_OBJECTS Function - lists objects in the specified location on object store. The results include the object names and additional metadata about the objects such as size, checksum, creation timestamp, and the last modification timestamp.


 

New PL/SQL Packages Added

(Shared Infrastructure Only)

 

Both UTL_HTTP and UTL_SMTP PL/SQL packages are now supported by Autonomous Database. Both packages are subjected to a number of restrictions which are clearly explained in the documentation - see links below.

 

For more information about using UTL_HTTP and UTL_SMTP in ADW click here.

Schema Advisor Updated

 

A new release has been posted to Autonomous Database Schema Advisor. Here are the new features in this release:

  • Added support for Database 10g source DBs
  • Capture all user-defined schemas using schemas=>'ALL'
  • Modify the Advisor checks for latest lockdown profiles
  • Simplify the installation process using a single SQL script
  • Provide a SQL interface to Advisor results - helps with integrating other internal/external tools
  • Several performance optimizations were implemented

November 2019

OCI Console - Shortcut to Built-in Tools (SQL Developer Web, APEX, OML Admin)

(Shared Infrastructure Only)

 

The UI for the Oracle Cloud Infrastructure Console has been updated with the addition of a new tools tab alongside the existing tabs for information and tags. The new Tools tab provides a simpler way for Cloud Admins to access and manage the built-in development tools such as SQL Developer Web, APEX and Oracle Machine Learning.

ADB Logo
 

SQL Developer Web - Data Loading

(Shared Infrastructure Only)

 

The ORDS tier portion of Oracle Autonomous Database (Shared Infrastructure) has been updated to version 19.2.1.

This covers both the commercial and Always Free versions of both Data Warehouse and Transaction Processing shapes.

This had two significant impacts on the user interface for SQL Developer Web:

  • Easier sign-in process for users other than ‘admin’
  • Ability to load data from a file on your machine to a table


ADB Logo
 
 

October 2019

Database-Specific Wallet

 

On the Database Connection form, it is now possible to select type of wallet that will be generated:

  • Instance Wallet - provides a database-specific wallet with access to a single database only.
     
  • Regional Wallet - contains connection details for all ADBs within a given tenant-region.

Note that the instance (database-specific) wallet is the recommended option for applications where the connection is to only one system.

ADB Logo

External Partitioned Tables

(Shared Infrastructure Only)

 

This new feature, external partitioned table, creates the ability to query multiple data files in the Object Store as a single external table where the Object Store files can be represented as multiple logical partitions.

The key benefit of using external partitioning tables is improved query performance - when the external data is partitioned into separate slices/parts, query response time is faster when processing only a small part of the data instead of having to scan the entire data set.

Hybrid Partitioned Tables

(Shared Infrastructure 19c Preview only)

 

Hybrid partitioned tables allows a query to access both internal data and multiple data files in the Object Store as single logical table.

Autonomous Database takes advantage of the partitioning information, ensuring that the query only accesses the relevant internal data and/or data files in the Object Store.

19c Preview

(Shared Infrastructure Only)

 

With 19c Preview version of Oracle Autonomous Database customers and partners will be able to test their applications, workloads, and 3rd party tools on upcoming features of Oracle Autonomous Database prior to general rollout of this new production version. Preview allows customers/partners to either create new ADB instances using Oracle Database 19c or to clone existing instances to the 19c Preview version.

Image of 19c Preview Collateral

More Data Loading Options For Numeric Formats

 

With the addition of numberformat and numericcharacters format options Autonomous Database now supports a wider range of formats for interpreting numeric strings during data loading operations. It is now possible to:

Specify the characters to use as the group separator and decimal character.

  • decimal_character: The decimal separates the integer portion of a number from the decimal portion.
  • group_separator: The group separator separates integer groups (that is, thousands, millions, billions, and so on).

Specify the number format model. A number format model is composed of one or more number format elements and is used in combination with numericcharacters.

Updated Schema Advisor Tool

 

The ADB Schema Advisor is a light-weight utility that analyzes on-premise or cloud Oracle Database schemas for the suitability of migration to Oracle Autonomous Database. The Advisor has been updated and is available for download via the Oracle Support website. This latest version includes support for ADW Dedicated, analyzing user defined objects placed in SYS/SYSTEM schemas and the ability to run multiple schemas from the command line.

 

September 2019

ADW Dedicated

 

Announcing the General Availability (GA) of dedicated deployment choice for Autonomous Data Warehouse.

As with Autonomous Transaction Processing, Autonomous Data Warehouse now offers both Shared Infrastructure (ADW-S) and Dedicated Infrastructure (ADW-D) deployment choices.

Serverless is a simple and elastic deployment choice. Oracle autonomously operates all aspects of the database life cycle from database placement to backup and updates. Dedicated is a private cloud in public cloud deployment choice. A completely dedicated compute, storage, network and database service for only a single tenant. Dedicated deployment provides for the highest levels of security isolation and governance. The customer has customizable operational policies for Autonomous Operations for workload placement, workload optimization, update scheduling, availability level, over provisioning and peak usage.

ADB dedicated customers can now deploy a mix of ADW-D and ATP-D instances on the same Exadata Infrastructure rack.

Always Free Service

 

ADB now offers 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 accounts that are in a trial period, paying status, or are always free.

Data Safe for ADB

 

Data Safe is a unified control center for your Oracle Databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Data Safe with Oracle Autonomous Database delivers essential data security capabilities as a service on Oracle Cloud Infrastructure.

Integration with OCI Work Requests

 

Many Autonomous Database operations do not take effect immediately. For example, when you create a new instance, it might take a few minutes for the instance to transition from the provisioning state to running. When you launch some longer-running operations, ADB now generates an OCI work request. A work request is an activity log that enables you to track each step in the operation's progress.

If an operation fails, a work request can help you determine which step of the process had an error.

OCI Metrics for ADB

 

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

Using Public URLs with DBMS_CLOUD

 

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. Check your specific cloud object storage service for details on how to make an object public in a supported object store.

Note:Carefully assess the business requirement and the security ramifications of using public URLs. When you use public URLs, due to the file content not being authenticated, make sure this is appropriate for your use.

You can use a public URL in any DBMS_CLOUD procedure that takes a URL to access files in your object store, without the need to create a credential. You need to either specify the credential_name parameter as NULL or not supply a credential_name parameter.

Availability of the Sao Paulo data center

 

Autonomous Data Warehouse is now available in the Sao Paulo data center.

Availability of the Sydney data center

 

Autonomous Data Warehouse is now available in the Sydney data center.

August 2019

Integration with OCI Events Services

 

The OCI Events Service now covers Autonomous Databases (Serverless and Dedicated). OCI Events lets you subscribe to changes in your cloud resources and respond to them by using OCI Notifications, OCI Streaming and Oracle Functions.

Autonomous Database instances generate events for the following resources;

  • Autonomous Database
  • Autonomous Container Database
  • Autonomous Exadata Infrastructure

and covers events such as start of backup, end of backup, create instance-start, create instance-end and maintenance reminders. The full list of supported event types is provided in the presentation listed below in the section headed "DEMO".

Support for Directory Objects

 

ADB now supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB. For example this simplifies the migration process for customers who have existing ETL jobs that create and drop specific database directories that are used to hold temporary data pump files as part of a data loading workflow.

To create additional directories within an ADB instance cloud administrators and applications can use the standard CREATE DIRECTORY and DROP DIRECTORY commands. The DBMS_CLOUD.LIST_FILES procedure can be used to list the contents of a directory.

Availability of the Mumbai data center

 

Autonomous Data Warehouse is now available in the Mumbai data center.

Availability of the Zurich data center

 

Autonomous Data Warehouse is now available in the Zurich data center.

July 2019

OCI VCN Transit Routing to Oracle Cloud Services

 

On-premises instances/applications no longer need a public IP address, NAT or FastConnect public peering to access the business-critical Oracle services in the Oracle Services Network

This means that on-premise private workloads can initiate connections to Oracle services. Traffic to the Oracle Services is sent via FastConnect peering connection (or VPN Connect) to the DRG in the hub VCN. DRG will then direct the Oracle services traffic to the SGW in the same VCN.

Moving instances between compartments

 

A compartment is allocated when a new ADB instance is created. Previously it has not been possible to move the instance to another compartment. With the launch of this feature, it is now possible to move an Autonomous Database from one compartment to another without interrupting the service.

Resetting Resource Management Rules to the defaults

 

The service console has a UI utility called "Set Resource Management Rules" to specify run-away criteria (query run-time and amount of IO) and CPU/IO shares for each consumer group.

The resource management UI now has a simple button called "Load Default Values" next to the "Save Changes" button. When clicked, the values of the active tab (either 'CPU/IO shares' or 'Run-away criteria') will be reset to their default, out-of-the-box, values.

Native Object Store Authentication for DBMS_CLOUD

 

Now DBMS_CLOUD offers native authentication and uses native APIs as an alternative to the Swift API. The previous Swift authentication (auth tokens) will remain for backward compatibility, however, we recommend customers and partners switch to using the new native API-based approach.

Simplified Service Console UI

 

The ADB Service console used to have several administration-related and development-related operations stacked under the "Administration" tab. In order to provide a better separation between these roles, the UI has been updated with an additional tab called "Development":

ISO-27001, 27017 and 27018 certifications

 

The GRC team has announced that Autonomous Database (ADW and ATP) has achieved ISO/IEC 27001, ISO/IEC 27017 and ISO/IEC 27018 certifications. For more information visit the OCI GRC Portal home page.

ODI on OCI Marketplace

 

Oracle Product Management and Development are pleased to announce ODI image on the OCI Marketplace. This image provides fast and easy ways to deploy full instance of Oracle Data Integrator on OCI. It contains pre-built ODI repository and ODI agent which is ready for you to start creating data flow mappings. The image also simplifies Autonomous Database configuration in the ODI repository to provide quick start to ADW data loading projects.

The Marketplace image contains a pre-built ODI repository and is pre-patched with all the latest patches, and include all the connectors for Oracle Autonomous Database, Fusion Application sources, databases, files and much more.

OCI Performance Hub

 

Customers can now get a real-time and historical view of performance data directly on the OCI console using Performance Hub. This new page contains the following:

  • Time Range field and time slider
  • Active Session History (ASH) Analytics tab
  • SQL Monitor tab

These features provides a simple one-click way to access the same information as found in EM Express, Oracle Management Cloud (OMC), and SQL Developer Web. The most likely target audience for this new feature will be cloud DBAs who manage a range of ADB instances within a single tenant and need a simple and fast way to monitor the performance of individual ADB instances directly from within the OCI Console.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud Infrastructure console.

When you select auto scaling Autonomous Database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. 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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul data center

 

Autonomous Database is now available in the Seoul data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo data center

 

Autonomous Database is now available in the Tokyo data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing have converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases.

There is a new 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.

February 2019

Application Continuity Support

 

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.

It is used to improve the user experience when handling both unplanned outages and planned maintenance. Application Continuity enhances the fault tolerance of systems and applications that use an Oracle database.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto data center

 

Autonomous Data Warehouse is now available in the Toronto data center.

August 2019

Integration with OCI Events Services

 

The OCI Events Service now covers Autonomous Databases (Serverless and Dedicated). OCI Events lets you subscribe to changes in your cloud resources and respond to them by using OCI Notifications, OCI Streaming and Oracle Functions.

Autonomous Database instances generate events for the following resources;

  • Autonomous Database
  • Autonomous Container Database
  • Autonomous Exadata Infrastructure

and covers events such as start of backup, end of backup, create instance-start, create instance-end and maintenance reminders. The full list of supported event types is provided in the presentation listed below in the section headed "DEMO".

Support for Multiple Directories

 

ADB now supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB. For example this simplifies the migration process for customers who have existing ETL jobs that create and drop specific database directories that are used to hold temporary data pump files as part of a data loading workflow.

To create additional directories within an ADB instance cloud administrators and applications can use the standard CREATE DIRECTORY and DROP DIRECTORY commands. The DBMS_CLOUD.LIST_FILES procedure can be used to list the contents of a directory.

Availability of the Mumbai data center

 

Autonomous Data Warehouse is now available in the Mumbai data center.

Availability of the Zurich data center

 

Autonomous Data Warehouse is now available in the Zurich data center.

July 2019

OCI VCN Transit Routing to Oracle Cloud Services

 

On-premises instances/applications no longer need a public IP address, NAT or FastConnect public peering to access the business-critical Oracle services in the Oracle Services Network

This means that on-premise private workloads can initiate connections to Oracle services. Traffic to the Oracle Services is sent via FastConnect peering connection (or VPN Connect) to the DRG in the hub VCN. DRG will then direct the Oracle services traffic to the SGW in the same VCN.

Moving instances between compartments

 

A compartment is allocated when a new ADB instance is created. Previously it has not been possible to move the instance to another compartment. With the launch of this feature, it is now possible to move an Autonomous Database from one compartment to another without interrupting the service.

Resetting Resource Management Rules to the defaults

 

The service console has a UI utility called "Set Resource Management Rules" to specify run-away criteria (query run-time and amount of IO) and CPU/IO shares for each consumer group.

The resource management UI now has a simple button called "Load Default Values" next to the "Save Changes" button. When clicked, the values of the active tab (either 'CPU/IO shares' or 'Run-away criteria') will be reset to their default, out-of-the-box, values.

Native Object Store Authentication for DBMS_CLOUD

 

Now DBMS_CLOUD offers native authentication and uses native APIs as an alternative to the Swift API. The previous Swift authentication (auth tokens) will remain for backward compatibility, however, we recommend customers and partners switch to using the new native API-based approach.

Simplified Service Console UI

 

The ADB Service console used to have several administration-related and development-related operations stacked under the "Administration" tab. In order to provide a better separation between these roles, the UI has been updated with an additional tab called "Development":

ISO-27001, 27017 and 27018 certifications

 

The GRC team has announced that Autonomous Database (ADW and ATP) has achieved ISO/IEC 27001, ISO/IEC 27017 and ISO/IEC 27018 certifications. For more information visit the OCI GRC Portal home page.

ODI on OCI Marketplace

 

Oracle Product Management and Development are pleased to announce ODI image on the OCI Marketplace. This image provides fast and easy ways to deploy full instance of Oracle Data Integrator on OCI. It contains pre-built ODI repository and ODI agent which is ready for you to start creating data flow mappings. The image also simplifies Autonomous Database configuration in the ODI repository to provide quick start to ADW data loading projects.

The Marketplace image contains a pre-built ODI repository and is pre-patched with all the latest patches, and include all the connectors for Oracle Autonomous Database, Fusion Application sources, databases, files and much more.

OCI Performance Hub

 

Customers can now get a real-time and historical view of performance data directly on the OCI console using Performance Hub. This new page contains the following:

  • Time Range field and time slider
  • Active Session History (ASH) Analytics tab
  • SQL Monitor tab

These features provides a simple one-click way to access the same information as found in EM Express, Oracle Management Cloud (OMC), and SQL Developer Web. The most likely target audience for this new feature will be cloud DBAs who manage a range of ADB instances within a single tenant and need a simple and fast way to monitor the performance of individual ADB instances directly from within the OCI Console.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud Infrastructure console.

When you select auto scaling Autonomous Database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. 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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul data center

 

Autonomous Database is now available in the Seoul data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo data center

 

Autonomous Database is now available in the Tokyo data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing have converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases.

There is a new 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.

February 2019

Application Continuity Support

 

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.

It is used to improve the user experience when handling both unplanned outages and planned maintenance. Application Continuity enhances the fault tolerance of systems and applications that use an Oracle database.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto data center

 

Autonomous Data Warehouse is now available in the Toronto data center.

June 2019

Application Express

 

Autonomous Database now includes Oracle's premiere low-code development platform: Application Express (APEX). This provides a low-code development environment that enables customers and partners to build stunning, scalable, secure apps with world-class features fully supported by Autonomous Database.

SQL Developer Web

 

Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. It provides a subset of the features available in the desktop product.

Support for Oracle REST Data Services

 

Oracle Rest Data Services (ORDS) is now included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. This means it is now extremely easy to develop modern REST interfaces for relational and JSON data in the Oracle Autonomous Database.

Support for SODA for REST

 

Autonomous Data Warehouse supports Simple Oracle Document Access (SODA) for REST. SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database. You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

Azure Object Store Support in Data Pump Import

 

This latest update means that Data Pump Import now lets you import data from Data Pump files residing on Micrososft Azure's object store.

Auto Scaling

 

You can select auto scaling during provisioning or later using the Scale Up/Down button on the Oracle Cloud Infrastructure console.

When you select auto scaling Autonomous Database can use up to three times more CPU and IO resources than specified by the number of OCPUs currently shown in the Scale Up/Down dialog. 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.

May 2019

Support for Oracle Spatial

 

Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and functions. These support the management and analysis of basic geometries; points such as GPS locations, lines such as roads, and polygons such as countries, proximity and containment queries, spatial aggregation, spatial joins, distance/area calculations and much more..

Support for Oracle Text

 

Autonomous Data Warehouse now supports Oracle Text. This makes it possible to perform linguistic analysis using a variety of strategies including keyword searching, context queries, Boolean operations, pattern matching and mixed thematic queries.

Support For Outgoing Database Links

 

It is now possible to create a database link from an ADW instance to any database that is accessible from an ADW including other ADW/ATP instances.

HIPAA

 

The Health Insurance Portability and Accountability Act (HIPAA) is a US law passed by Congress in 1996. Among other requirements, the act establishes privacy and security rules for protected health information (PHI) and aims to make electronic health records (EHR) widely adopted.

Autonomous Database demonstrates its HIPAA fitness through an additional attestation prepared in accordance with AICPA SSAE 18, AT-C sections 205 and 315.

Set CPU/IO Shares

 

Autonomous Data Warehouse now allows customers to change the CPU/IO shares for the consumer groups within their ADW instance (high, medium, low). This allows for use cases where, for example, a workload running in the LOW resource group requires a greater share of CPU and IO resources than HIGH and MEDIUM.

Availability in the Seoul region

 

Autonomous Database is now available in the Seoul region data center.

Integration with Oracle Management Cloud

 

Oracle Management Cloud now supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. The Performance Hub page provides both high-level and detailed performance metrics for your Autonomous Database instances. Use of Oracle Management Cloud is included as part of your Autonomous Data Warehouse and Autonomous Transaction Processing services.

Support for pre-authenticated URLs

 

If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs. When a pre-authenticated request is created, a unique URL is generated. This unique URL can then be provided to users, partners, or third parties to access the Object Storage resource target identified in the pre-authenticated request.

Support for XML

 

Oracle XML DB features are now supported in Autonomous Database. This enables existing customers who currently use XML DB to more easily migrate to Autonomous Database. These features also enables all Autonomous Database customers to easily query and access XML data. Please note that some Oracle XML DB features are restricted so refer to the documentation for a complete list of supported features.

Native URL support in Data Pump

 

In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIs. Note that Swift-style URIs are still supported, which means that your existing scripts will continue to work.

Availability of the Tokyo region

 

Autonomous Database is now available in the Tokyo region data center.

April 2019

Support for Network ACLs

 

A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. Once an access control list is set that specific Autonomous Data Warehouse database only accepts connections from addresses on the access control list and rejects all other client connections

Support for Avro files

 

Avro is a common data format in big data solutions. One of its key benefits is that it enables efficient data exchange between applications and services. Using a similar approach to accessing parquet files, Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data types. Avro files may include complex types – like arrays, structs, maps and more; ADW supports avro files that contain Oracle data types.

Change License Type

 

you can now quickly and easily change the licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.

March 2019

Data Warehouse Cloning

 

Autonomous Data Warehouse provides cloning where you can choose to clone either the full database or only the database metadata. So it's now possible with just a few simple mouse-clicks to provision a perfect clone of your existing autonomous data warehouse instance. This is the perfect way to provision new environments such as sandboxes, QA, training, testing etc to support your data warehouse project.

ADB Gains SOC Compliance

 

Autonomous Data Warehouse has achieved SOC 1 and SOC 2 compliance. SOC was created because of the rise of cloud computing and outsourcing of functions to service organizations. Liability concerns caused a demand in assurance of confidentiality and privacy of information processed in the cloud.

Enhanced, Faster Connectivity Options

 

Oracle Cloud Infrastructure FastConnect provides an easy way for you to connect your on-premises network to Autonomous Data Warehouse using FastConnect Public Peering. FastConnect provides higher-bandwidth options, and a more reliable and consistent networking experience compared to internet-based connections.

UI and API Unification for Autonomous Database

 

Oracle Cloud Infrastructure Console and the Oracle Cloud Infrastructure APIs for Autonomous Data Warehouse and Autonomous Transaction Processing have converged to a single, unified framework. These changes allow you to more easily manage both types of Autonomous Databases.

There is a new 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.

February 2019

Application Continuity Support

 

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.

It is used to improve the user experience when handling both unplanned outages and planned maintenance. Application Continuity enhances the fault tolerance of systems and applications that use an Oracle database.

January 2019

Parquet File Support

 

Parquet is a file format that is commonly used by the Hadoop ecosystem. Unlike CSV, parquet is really a database file type. Embedded metadata describe a file's contents and data is stored in compressed, columnar format and has been designed for efficient data access.

Parquet provides predicate pushdown (i.e. extract data based on a filter expression), column pruning and other optimizations.

Autonomous Data Warehouse now supports simplified table creation, querying and loading data from parquet files stored in object stores and takes advantage of these query optimizations.

Availability of the Toronto region

 

Autonomous Data Warehouse is now available in the Toronto region.

November 2018

Availability of the London region

 

Autonomous Data Warehouse is now available in the London region.

October 2018

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 now includes new role-based topic links:

  • Business Analyst
  • Cloud Administrator
  • Cloud Architect
  • Data Warehouse Developer

September 2018

Table compression methods

 

In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous Data Warehouse.

For more information, see the section headed "Managing DML Performance and Compression" in the documentation guide.

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 the section headed "Managing Concurrency and Priorities on Autonomous Data Warehouse" in the documentation guide.

August 2018

Launch of Autonomous Transaction Processing

 

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

SQL Developer - new connection process

 

SQL Developer 18.2.0 and later now allows for setting up connections without the need for keystore passwords.

June 2018

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

 

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.

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.

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

Object Storage Credentials

 

The term "Swift Password" has been replaced with the term "Auth token" in the documentation and UI.

April 2018

Microsoft Azure 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.

Test Drive New Data Warehouse Features In Database 19c