Previous Feature Announcements

Announcements for the important changes made to Oracle Autonomous Database Serverless.

See What’s New for Oracle Autonomous Database Serverless for feature announcements in 2023.

2024 What's New

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2024.

December 2024

Feature Description

Immutable Backup Retention

The Immutable backup retention option allows you to lock the automatic backup retention period. If locked, Autonomous Database does not allow changes to the retention period for automatic backups.

See About Backup and Recovery on Autonomous Database for more information.

AutoML Pipeline

AutoML Pipeline automates the three major stages of the machine learning pipeline:

  • Algorithm selection
  • Adaptive data reduction (feature and sample size selection)
  • Hyperparameter optimization

See AutoML Pipeline for more information.

OML4Py Metrics

OML4Py Metrics provides metrics to evaluate the performance of machine learning models.

See OML4Py Metrics for more information.

SQL Query Performance Event: QueryPerformanceDegradationDetected

The QueryPerformanceDegradationDetected information event is triggered when the average elapsed time of a query has exceeded ten times its average elapsed time over the past seven (7) days.

See Information Events on Autonomous Database for more information.

Refreshable Clone Events: AutomaticRefreshEnd and AutomaticRefreshFailed

The AutomaticRefreshEnd and AutomaticRefreshFailed information events are generated when a scheduled Automatic Refresh completes or when a scheduled Automatic Refresh fails.

See Information Events on Autonomous Database for more information.

November 2024

Feature Description

Data Marketplace in Data Studio

Data Marketplace provides an innovative platform to access and share datasets effortlessly with Autonomous Database. The Data Marketplace is a part of the Data Studio suite of tools that provides you access to load and query datasets for your organizational requirements. You can access and discover data sets curated by data providers.

See The Data Marketplace Tool for more information.

PAR URL Table View with Column Level Group By and UI Options

You can access Pre-Authenticated Request (PAR) URL data from a browser and group the data by the values of cells in a column. You can also specify view options such as sorting, filtering, and cell color by column.

See Generate a PAR URL with UI Features Specified on Columns for more information.

Network Usage Events: NetworkUsageInbound and NetworkUsageOutbound

The NetworkUsageInbound and NetworkUsageOutbound information events are triggered when the average incoming network traffic or average outgoing network traffic to your Autonomous Database over the previous 24 hours has exceeded 50% of the average incoming or outgoing traffic.

See Information Events on Autonomous Database for more information.

Maintenance Window Details on OCI Console

The Oracle Cloud Infrastructure Console Autonomous Database details page shows additional information on upcoming maintenance. When Autonomous Data Guard is enabled this includes maintenance information for a local standby database.

See About Scheduled Maintenance and Patching for more information.

Microsoft SharePoint Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Use Autonomous Database Oracle-managed heterogeneous connectivity to create database links to Microsoft SharePoint. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Customer-Managed Keys with Cross-Region Disaster Recovery

Replication of key vaults across regions for a cross-region Disaster Recovery Peer is now supported both with OCI Vault default vault and virtual private vault options.

See Manage Master Encryption Keys in OCI Vault for more information.

October 2024

Feature Description

Bring Your Own License (BYOL) Option Moved for Provisioning and Cloning

During provisioning or cloning the Bring Your Own License (BYOL) option is moved to advanced options in the Configure the database area.

See Choose Bring Your Own License Option While Provisioning or Cloning for more information.

Blocking Sessions Metric

The BlockingSessions metric shows the number of current blocking sessions.

See Available Metrics: oci_autonomous_database for more information.

Control Lockdown Profile Errors

Autonomous Database uses lockdown profiles to restrict certain database functionality and features. The LOCKDOWN_ERRORS parameter allows you to suppress lockdown profile errors.

See LOCKDOWN_ERRORS for more information.

NVIDIA GPU Compute Capabilities with Oracle Machine Learning Notebooks

Oracle Machine Learning Notebooks offers support for NVIDIA GPUs (Graphics Processing Unit) compute capabilities. The GPU capabilities in OML Notebooks allow you to run advanced machine learning algorithms such as deep learning models, transformers (embedding models) for generating vectors, and small LLMs.

The GPU feature is enabled for Autonomous Database instances with Transaction Processing or Data Warehouse workloads with 16 ECPUs or more specified for the OML application.

GPU resources are not available on Always Free or Autonomous Database for Developers instances.

See Enable GPU Compute Capabilities in a Notebook through the Python Interpreter for more information.

Customer-Managed Encryption Keys

In addition to Oracle Cloud Infrastructure Vault, Autonomous Database can be configured to use encryption keys with the following key providers:

  • Azure Key Vault
  • AWS Key Management System (KMS)
  • Oracle Key Vault (OKV)

See Manage Encryption Keys on Autonomous Database for more information.

Select AI with Hugging Face

Autonomous Database can interact with AI service providers. Select AI supports OpenAI, Anthropic, Azure OpenAI Service, CohereAI, Google Gemini, Hugging Face, and OCI Generative AI.

This feature supports having LLMs work with Oracle database by generating SQL from natural language prompts. This allows you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

Zero Trust Packet Routing

Oracle Cloud Infrastructure Zero Trust Packet Routing (ZPR) protects sensitive data from unauthorized access through intent-based security policies that you write for resources, such as an Autonomous Database on a private endpoint, that you assign security attributes to.

See Use Zero Trust Packet Routing on Autonomous Database for more information.

Select AI with Anthropic

Autonomous Database can interact with AI service providers. Select AI supports OpenAI, Anthropic, Azure OpenAI Service, CohereAI, Google Gemini, Hugging Face, and OCI Generative AI.

This feature supports having LLMs work with Oracle database by generating SQL from natural language prompts. This allows you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

Data Studio Enhancements

The Data Studio is updated with new features and changes in the following areas:

  • Data Load in Data Studio- Public APIs for Data Load Live Feed:

    The LiveFeed Data Studio feature now has public PL/SQL APIs.

    See DBMS_LIVE_FEED Package Reference for more information.

  • Data Studio Settings Changes:
    • Support for non-Oracle Cloud Infrastructure (OCI) Cloud Services

      Data Studio now supports loading and linking to data in AWS and Azure. In addition, it supports AI Profiles from AWS.

    • Support for Policy checking in Data Studio

      Data Studio utilizes many OCI services to enrich your experience. If your OCI credential is missing policies, these features fail, typically silently. The Data Studio Settings UI now allows you to test your credential and see which features are likely to work, and which require missing policies.

    • Improved Day-one user experience

      Several improvements around Settings experiences have been added, so users are successful in their tasks.

    See Data Studio Settings for more information.

  • Data Studio Analysis- Explain query using AI:

    The Data Analysis tool already had AI support to generate SQL from a text prompt. You can now utilize AI to explain the SQL queries the tool generates in text format.

    See Generate Natural Language explanation from SQL Query using AI Explain for more information.

  • Data Studio Analysis- Vector Search for Text:

    You can use Oracle AI Vector Search capabilities to search for relevant text from your source data on a specific column. The Vector Search helps quickly locate and match data that is similar to the text you provide as your search input.

    See Vector Search in the Data Analysis Tool for more information.

September 2024

Feature Description

Implicit Partitioning for External Tables

You can create implicit partitioned external tables on your Autonomous Database from Hive style partitioned data or from simple folder partitioned data stored on your Cloud Object Store.

See Query External Tables with Implicit Partitioning for more information.

Use Select AI to Generate Synthetic Data

You can generate synthetic data using LLMs that conforms to your schema for solution testing, proofs of concept, and other uses. Synthetic data can be used for better testing of your applications when real data is not available and can also be used to populate an Autonomous Database clone or a metadata clone.

See Synthetic Data Generation for more information.

Use Select AI Retrieval Augmented Generation (RAG)

Select AI enables SQL access to generative AI using Large Language Models (LLMs) and embedding models. This includes support for natural language to SQL query generation and retrieval augmented generation, among other features.

See Use Select AI for Natural Language Interaction with your Database for more information.

Select AI with Google Gemini

Autonomous Database can interact with AI service providers. Select AI supports Google Gemini, OCI Generative AI, Azure OpenAI Service, OpenAI, and CohereAI.

This feature supports having LLMs work with Oracle database by generating SQL from natural language prompts. This allows you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

Undelete Database

With the ECPU compute model, you have the option to undelete a terminated Autonomous Database instance.

See Undelete a Terminated Autonomous Database Instance for more information.

August 2024

Feature Description

Use Database In-Memory with Autonomous Database

You can now declare your tables as in-memory to enable the Database In-Memory feature on Autonomous Database. This feature can significantly improve performance for real-time analytics and mixed workloads.

See Use Database In-Memory with Autonomous Database for more information.

Disaster Recovery Peer Lag Metric

The PeerLag metric shows the total time in seconds by which the Disaster Recovery peer lags behind its Primary database.

See Available Metrics: oci_autonomous_database for more information.

Create Credential Cloud Shell script enhancements

The adb-create-cred.sh Create Credential Cloud Shell script used to create OCI Native Credentials and Auth Token in your Autonomous Database supports new arguments: username and credential.

See Create Credentials to Access Cloud Services in Cloud Shell for more information.

Upgrade by Cloning from Oracle Database 19c to Oracle Database 23ai

When you clone an Autonomous Database instance and the source database version is Oracle Database 19c, in regions where Oracle Database 23ai is available, you can choose either Oracle Database 19c or Oracle Database 23ai for the clone.

See Manually Upgrade by Performing a Full Clone for more information.

View Network Information on the OCI Console

On the Oracle Cloud Infrastructure Console you can view the network information for your Autonomous Database.

See View Network Information on the OCI Console for more information.

Export and Import Operations Run as Jobs in Data Transforms

You can now use the Jobs page to see the status of the export or import process that is currently running.

See Export Objects for more information.

July 2024

Feature Description

Migrate Applications from Non-Oracle Databases to Autonomous Database

You can translate SQL statements written for a non-Oracle SQL database to Oracle SQL in your Autonomous Database.

See Migrate Applications from Non-Oracle Databases to Autonomous Database for more information.

Autonomous Database 23ai Available in the Paid Tier

Autonomous Database with Oracle Database 23ai in the Paid tier is available in all commercial public cloud regions except the following regions: Colombia Central: Bogota (BOG), Saudi Arabia Central: Riyadh (RUH), Singapore West: Singapore (XSP), and Spain Central: Madrid (MAD).

See Provision an Autonomous Database Instance and Clone an Autonomous Database Instance for more information.

Update for Oracle-Managed Heterogeneous Connectivity Database Links

Autonomous Database support for Oracle-managed heterogeneous connectivity with database links for Azure, the two optional parameters include: auth_method and domain to support NTLM/AD authentication.

Autonomous Database support for Oracle-managed heterogeneous connectivity with database links for Snowflake, the optional parameters include: role, schema, and warehouse. These values specify a different schema, role, or warehouse value, other than the default.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

OCI Full Stack Disaster Recovery

You can enable the Oracle Cloud Infrastructure Full Stack Disaster Recovery on Autonomous Database.

See Use OCI Full Stack Disaster Recovery with Autonomous Database for more information.

Updated Object Storage URL Format using Dedicated Endpoints for commercial (OC1) realms

Autonomous Database supports Oracle Cloud Infrastructure Object Storage URI formats for commercial (OC1) realms.

See Import Data Using Oracle Data Pump on Autonomous Database and Move Data with Data Pump Export to Object Store, for Oracle Data Pump examples.

Pre-Authenticated Request (PAR) URL Enhancements

Pre-Authenticated Request (PAR) URL enhancements include:

Use RESULT_CACHE Hint to Cache Data for a Cloud Links Consumer

You can enable caching on a data set consumer to cache the results of a query or for a query fragment that accesses Cloud Link data.

See Enable Caching for a Cloud Link Consumer for more information.

Updated Object Storage URL Format in DBMS_CLOUD
Autonomous Database supports the updated Oracle Cloud Infrastructure Object Storage URI formats in DBMS_CLOUD for:
  • OCI Native
  • Swift
  • S3 Compatible
  • Pre-Authenticated Requests (PAR)

See DBMS_CLOUD URI Formats for further information.

Text Indexing and Search on JSON Files in Object Storage

You can build a JSON search index on documents residing in files stored in Object Storage, which allows you to search fields in your JSON documents using JSON_TEXTCONTAINS, and use wildcards in your search.

See Use JSON Search on Documents in Object Storage for more information.

Documentation Addition: Go Application Connection Information

You can connect Go applications to your Autonomous Database instance either with a wallet (mTLS) or without a wallet (TLS).

See Connect Go Applications to Autonomous Database for more information.

Database Actions Data Studio Updates

The Data Studio in Database Actions is updated with new features and changes in the following areas:
  • New Catalog page:

    The new catalog page features faceted search for easy filtering, presentation by entity type, better defaults for catalog features, and many other small improvements.

    See The Catalog Page.

  • Data Load support for Boolean data type:

    The Data Load tool now supports loading Boolean data from source files into the new Oracle Database 23ai Boolean data type.

    See Loading Data.

  • Data Load from Image Files:

    The Data Load tool supports loading images of tabular data into relational tables. The supported file formats are PDF, Tif and JPEG formats.

    See Use OCI Document Understanding to extract Tables from Images.

  • Data Load support for Vector data type:

    The Data Load tool supports loading into the 23ai VECTOR data type.

    See Loading Data.

  • Support data load from Iceberg files:

    Data Studio can now link and create an external table on or load Iceberg tables from the object store.

    See Load Apache Iceberg Tables.

  • Rectify Geometry support for data load from GeoJSON files:

    Data Studio supports RECTIFY feature of GeoJSON spatial issues along with expression support for area and length.

    See Add Spatial Expression for GeoJSON columns.

  • Support for Language Detection using OCI AI Services:

    You can now add expressions to your target table to identify the language used in a column.

    See Use OCI Language Service Capabilities in Data Studio.

  • Data Studio enhancements for AWS Glue Administration:

    You can now add a new Glue Catalog and sync with a Glue catalog from the Data Studio tool.

    See Create Amazon Web Services (AWS) Credentials.

June 2024

Feature Description

Autonomous Database 23ai Available in the Paid Tier

Autonomous Database with Oracle Database 23ai in the Paid tier is available in all commercial public cloud regions except the following regions: Colombia Central: Bogota (BOG), Saudi Arabia Central: Riyadh (RUH), Singapore West: Singapore (XSP), and Spain Central: Madrid (MAD).

See Provision an Autonomous Database Instance and Clone an Autonomous Database Instance for more information.

Elastic Pool Usage Details in Oracle Cloud Infrastructure Usage Report and in OCI_USAGE_DATA View

You can obtain a detailed breakdown of elastic pool usage in the Oracle Cloud Infrastructure usage report and this information is also shown in the OCI_USAGE_DATA view.

See About Elastic Pool Billing for more information.

Documentation Addition: Provide Steps to Reduce Latency for Database Connections with Autonomous Data Guard

Provides information on the steps to take to configure an Autonomous Data Guard standby environment to reduce latency for database connections when you connect after a failover or after a switchover (when the standby becomes the Primary).

See Steps to Reduce Latency for Database Connections for Databases with Autonomous Data Guard for more information.

Bring Your Own License (BYOL) Input Option for BYOL Flexibility

Enable the option BYOL ECPU limit to select the BYOL flexible license option.

See Choose Bring Your Own License Option While Provisioning or Cloning and Choose Bring Your Own License on Autonomous Database (ECPU Compute Model) for more information.

Automate Creation of OCI Credentials using a Cloud Shell Script

Use the Cloud Shell to run a script that creates OCI Native Credentials and Auth Token in your Autonomous Database.

See Example: Create OCI Native Credentials and Run in Autonomous Database for more information.

Public Access Allowed for an Autonomous Database on a Private Endpoint

When you want to configure an Autonomous Database to use a private endpoint and you also want to allow connections from allowed public IPs or public VCNs, you can select the Allow public access option. This adds a public endpoint for a database that is configured on a private endpoint.

See Use a Private Endpoint with Public Access Allowed for more information.

TCP Fast Open (TFO) to Connect Clients to Autonomous Database

Use TCP Fast Open (TFO) connections when your application is sensitive to network latency and you want to decrease the network latency between your application and the database. TFO connections can improve application performance by decreasing network latency for client connections.

See Use TCP Fast Open (TFO) to Connect Clients to Autonomous Database for more information.

Oracle APEX 24.1

Autonomous Database uses Oracle APEX Release 24.1.

See Create Applications with Oracle APEX in Autonomous Database for more information.

Documentation Addition: Load Data from Google Cloud Storage

Provides an example for loading data into an Autonomous Database instance from Google Cloud Storage.

See Load Data into Autonomous Database from Google Cloud Storage for more information.

Shrink Storage for Tables with LONG Columns

Autonomous Database shrink operations will succeed for tables with LONG columns.

See Shrink Storage for more information.

Cross Tenancy Autonomous Standby

You can add a cross tenancy Autonomous Data Guard standby database. This creates an Autonomous Data Guard standby that resides in a different tenancy. The cross tenancy standby can be in the same region (local) or in a different region (cross-region)

See Use a Cross Tenancy Autonomous Data Guard Standby Database for more information.

Oracle Spatial AI Features for OML

Oracle Spatial AI is a set of capabilities in OML4Py for detecting patterns and making predictions from geospatial data. It includes features for end-to-end workflows, including spatial machine learning pipelines.

See About Oracle Spatial AI for more information.

YouTube Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Use Autonomous Database Oracle-managed heterogeneous connectivity to create database links to YouTube. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Data Transforms Updates

Data Transforms is updated with new features and changes in the following areas:

  • Export and Import Objects

    You can move Data Transforms objects such as projects, connections, data loads, data flows, workflows, and schedules from a Development environment to a Production environment.

    See Export Objects for more information.

  • Variables

    You can now create variables and use them as steps within data flows and workflows.

    See Create a Variable for more information.

  • Purge jobs

    Data Transforms allows you to purge older jobs to keep the repository clean and optimize performance.

    See Create and Manage Jobs for more information.

  • Load Views to target servers

    In addition to tables, Data Load allows you to load views from the source server. Views are stored as tables in the target server.

  • Support for the new Object Storage URL format

    Data Transforms includes support for the Object Storage URL format when you create an Object Storage connection.

    See Create an Oracle Object Storage Connection for more information.

  • OAuth 2.0 support for NetSuite connections

    You can now use OAuth 2.0 authentication to connect to Oracle NetSuite data sources.

    See Create and Use an Oracle NetSuite Connection for more information.

May 2024

Feature Description

Multiple Peers for Cross-Region Disaster Recovery

With the ECPU billing model, you have the option to create one or more cross-region standby databases for Autonomous Data Guard and multiple cross-region Backup-Based Disaster Recovery peers.

See Use Standby Databases with Autonomous Data Guard for Disaster Recovery and Use Backup-Based Disaster Recovery for more information.

Table Format with PAR URLs

You can access PAR URLs with a browser and view the returned data in table format.

See Use PAR URLs to Access Data in Table Format for more information.

Cross-Tenancy Access for IAM Users to Autonomous Database

Identity and Access Management (IAM) cross-tenancy user access to an Autonomous Database instance is similar to a single tenancy scenario except that tenancy information is required for mappings and token requests and a policy is required in both tenancies to allow this cross tenancy database resource access

See Accessing a Database Cross-Tenancy Using an IAM Integration for more information.

External Calls with a Customer-Managed Wallet

When your Autonomous Database instance is on a private endpoint you can use a customer-managed wallet with procedures in UTL_HTTP, DBMS_LDAP, UTL_SMTP, or UTL_TCP. You can also use a customer-managed wallet when the scheduler sends SMTP email notifications for various events related to scheduler jobs.

See Make External Calls Using a Customer-Managed Wallet for more information.

Allow Different ACLs on Cross-Region Disaster Recovery Peer

You can independently modify network ACLs on a remote disaster recovery peer database.

See Manage Remote Peer Network ACLs and Update Remote Peer Network ACLs for a Backup-Based Disaster Recovery Peer for more information.

Documentation Addition: Best Practices for Low Latency Connections

Provides information on steps you can take to reduce the latency for connections between an application and Autonomous Database.

See Best Practices for Low Latency Connections with Autonomous Database for more information.

Always Free with Oracle Database 23ai

The Oracle Database versions available for Always Free Autonomous Database are: Oracle Database 19c or Oracle Database 23ai.

See Always Free Autonomous Database for more information.

Autonomous Database Free Container Image with Oracle Database 23ai

The Oracle Database versions available for Autonomous Database Free Container Image are: Oracle Database 19c or Oracle Database 23ai.

See Use the Autonomous Database Free Container Image for more information.

April 2024

Feature Description

Cross-Region Cloud Links

You can use Cloud Links in multiple regions, where the source region contains the data set's source database and one or more remote regions contain refreshable clones of the source database.

See Register or Unregister a Data Set in a Different Region for more information.

Test Workloads Against an Upcoming Patch

Using the workload auto replay feature you can automatically capture a workload from a production database that is on the regular patch level and replay the workload on a target refreshable clone that is on the early patch level. This feature allows you to test an upcoming patch by running an existing workload that is in production against a patch before the patch reaches production.

See Test Workloads Against an Upcoming Patch for more information.

Cloning Permissions

You can control and limit cloning operations on Autonomous Database with IAM permissions.

See Cloning Permissions in IAM Permissions and API Operations for Autonomous Database for more information.

Data Studio Updates

The Data Studio is updated with new features and changes in the following areas:

  • Data Load Dashboard:

    A new Data Load Dashboard is available which displays summaries of the recent load jobs and their status and view details about the data you load.

    See The Data Load Page for more information.

  • Sentiment Analysis and Key Phrase Extraction on text-based columns:

    You can now perform Sentiment Analysis and Key Phrase Extraction on the Data Load tool to analyze text-based data.

    See Use OCI Language Service Capabilities in Data Studio for more information.

  • Data Load support to access Amazon Web Services (AWS) Glue Catalogs:

    The Data Load tool of Data Studio allows you to synchronize Autonomous Database with Amazon Web Service (AWS) Glue Data Catalog metadata.

    See Register AWS Glue Catalog for more information.

  • Data Load support for registration and synchronization of OCI Data Catalogs:

    The Data Load tool enables you to register and synchronize OCI Data Catalogs to create external tables in Autonomous Database.

    See Register OCI Data Catalog for more information.

  • Data Load support to load GeoJSON files:

    The Data Load tool supports loading GeoJSON files in Autonomous Database.

    See Use GeoJSON in Data Load for more information.

  • Data Load support to enable loading into other schemas:

    The Data Load tool allows an ADMIN to create and load data into other schemas.

    See Loading Data From Local Files for more information.

  • Enable Resource Principal using Data Studio:

    You can enable Resource Principals using Data Studio to authenticate and access Oracle Cloud Infrastructure resources.

    See Manage Resource Principal using Data Studio for more information.

Manage Oracle Cloud Operator Access

Oracle Cloud Operators do not have authorization to access your data or any other information in your database schemas. When access to your database schemas is required to troubleshoot or mitigate an issue, you can allow a cloud operator to access your Autonomous Database schemas for a limited time.

See Manage Oracle Cloud Operator Access for more information.

Apache Iceberg External Tables

Autonomous Database supports querying of Apache Iceberg tables stored in Amazon Web Services (AWS) or in Oracle Cloud Infrastructure Object Storage.

See Query Apache Iceberg Tables for more information.

Cloud Tables

You can create Cloud Tables where table data resides on Oracle managed Cloud Storage and the table data does not consume database storage.

See Use Cloud Tables to Store Logging and Diagnostic Information for more information.

Cloud Links Offload Targets Without Specifying Database IDs

Cloud Links support with the optional offload_targets parameter lets you specify that access is offloaded to refreshable clones. This parameter now supports the ANY keyword, where all data set requests from consumers are offloaded to a refreshable clone.

See Register a Data Set with Offload Targets for Data Set Access for more information.

Live Data Sharing Using Database Actions in Autonomous Database

Use Data Sharing to share data, as of the latest database commit, with Autonomous Databases in the same region. A Data Sharing recipient always views the latest data.

See Overview of the Data Share Tool for more information.

Updated Version of Autonomous Database Free Container Image

A new version of the Autonomous Database Free Container Image is available with updates and new features. Use the Autonomous Database Free Container Image to run Autonomous Database in a container in your own environment, without requiring access to Oracle Cloud Infrastructure Console or to the internet.

See Use the Autonomous Database Free Container Image for more information.

March 2024

Feature Description

Refreshable Clone Automatic Refresh Option

When you enable the automatic refresh option Autonomous Database automatically refreshes a refreshable clone with data from the source database.

See Refreshable Clone with Automatic Refresh Enabled and Edit Automatic Refresh Policy for Refreshable Clone for more information.

Invoke External Procedures

You can invoke external procedures written in the C language from Autonomous Database as SQL functions. You do not install external procedures on Autonomous Database. To use an external procedure, the procedure is hosted remotely on a VM running in an Oracle Cloud Infrastructure Virtual Cloud Network (VCN).

See Invoke External Procedures as SQL Functions for more information.

Network File System (NFS) NFSv4 Support

You can attach a Network File System to a directory location in your Autonomous Database. This allows you to load data from Oracle Cloud Infrastructure File Storage in your Virtual Cloud Network (VCN) or from any other Network File System in on-premises data centers. Depending on the version of the Network File System you want to access, both NFSv3 and NFSv4 are supported.

See Access Network File System from Autonomous Database for more information.

Support for Regular Expressions in DBMS_CLOUD Procedures

The format option regexuri is supported with the following DBMS_CLOUD procedures: COPY_COLLECTION, COPY_DATA, CREATE_EXTERNAL_TABLE, CREATE_EXTERNAL_PART_TABLE, and CREATE_HYBRID_PART_TABLE.

See DBMS_CLOUD Package Format Options for more information

Encrypt or Decrypt Data

For greater security you can encrypt data that you export to Object Storage. When data on Object Storage is encrypted you can decrypt the data you import or when you use the data in an external table.

See Encrypt Data While Exporting or Decrypt Data While Importing for more information.

JOB_QUEUE_PROCCESSES Initialization Parameter

You can set the JOB_QUEUE_PROCESSES initialization parameter. Setting this parameter to 0 disables non-Oracle supplied Scheduler jobs.

See JOB_QUEUE_PROCESSES for more information.

Pre-Authenticated Request URLs Access Information

You can generate and manage Pre-Authenticated Request (PAR) URLs for data on Autonomous Database and Autonomous Database provides views that allow you to monitor PAR URL usage.

See Monitor and View PAR URL Usage for more information.

UTL_HTTP allows HTTP_PROXY Connections

With UTL_HTTP, when the Autonomous Database instance is on a private endpoint you can call UTL_HTTP.set_proxy and both HTTPS and HTTP_PROXY connections are allowed.

See Submit an HTTP Request to a Private Host and PL/SQL Package Notes for Autonomous Database for more information.

February 2024

Feature Description

Pre-Authenticated Request URLs for Read Only Data Access

You can generate and manage Pre-Authenticated Request (PAR) URLs for data on Autonomous Database.

See Use Pre-Authenticated Request URLs for Read Only Data Access on Autonomous Database for more information.

Replicate Backups to a Cross-Region Disaster Recovery Peer

You can enable replication of automatic backups from a primary database to a cross-region disaster recovery peer. Up to seven days of automatic backups are available in the remote region when this feature is enabled.

See Replicating Backups to a Cross-Region Autonomous Data Guard Standby and Replicating Backups to a Cross-Region Backup Based Disaster Recovery Peer for more information.

Select AI with OCI Generative AI

Autonomous Database can interact with AI service providers. Select AI now supports OCI Generative AI, Azure OpenAI Service, OpenAI, and CohereAI.

This feature supports having LLMs work with Oracle database by generating SQL from natural language prompts. This allows you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

January 2024

Feature Description

ECPU Compute Model for all Workload Types

Autonomous Database offers two compute models when you create or clone an instance: ECPU and OCPU. Previously only the workload types Data Warehouse and Transaction Processing supported the ECPU compute model. Now all workload types support the ECPU compute model, including JSON and APEX.

See Compute Models in Autonomous Database for more information.

Manage Time Zone File Updates

Autonomous Database provides several options to automatically update time zone files.

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

Custom Kerberos Service Name Support for Kerberos Authentication

You can use a custom Kerberos service name when you configure Kerberos to authenticate Autonomous Database users. Using a custom service name you can use the same Keytab files on multiple Autonomous Database instances when you enable Kerberos authentication (you do not need to create and upload different Keytab files for each Autonomous Database instance).

See Configure Kerberos Authentication with Autonomous Database for more information.

Clone Database to Change Workload Type

You can create a clone of an Autonomous Database and select a different workload type for the cloned database.

See Clone Autonomous Database to Change Workload Type for more information.

2023 What's New

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2023.

December 2023

Feature Description

Cross Tenancy Cloning

You can clone an Autonomous Database instance from one tenancy, source tenancy, to a different tenancy (destination tenancy). The cross tenancy cloning option is only available using the CLI or the Autonomous Database REST APIs. This option is not available using the Oracle Cloud Infrastructure Console.

See Cross Tenancy and Cross-Region Cloning for more information.

Invoke Azure Remote Functions

You can invoke Azure remote functions in your Autonomous Database as SQL functions.

See Steps to Invoke Azure Functions as SQL Functions for more information.

Create Database Links to Oracle RAC Database

You can create database links from an Autonomous Database to a target Oracle RAC database and specify multiple hostnames.

See Create Database Links from Autonomous Database to an Oracle Database on a Private Endpoint for more information.

New Cloud Links Views

Obtain information on the Cloud Link specific privileges granted to all users or to the current user.

See Monitor and View Cloud Links Information for more information.

Documentation Addition: Load Data from AWS S3

Provides an example for loading data into an Autonomous Database instance from AWS S3.

See Load Data into Autonomous Database from AWS S3 for more information.

November 2023

Feature Description

Oracle APEX 23.2

Autonomous Database uses Oracle APEX Release 23.2.

See Create Applications with Oracle APEX in Autonomous Database for more information.

Select AI with Azure OpenAI Service

Autonomous Database can interact with AI service providers. Select AI now supports the Azure OpenAI Service, OpenAI, and CohereAI. One way LLMs can work with Oracle database is by generating SQL from natural language prompts that allow you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

Break Glass Access with SAAS_ADMIN User

Autonomous Database supports break glass access for SaaS providers. Break glass access allows a SaaS operations team, when explicitly authorized by a SaaS customer, to access a customer's database to perform critical or emergency operations.

See Break Glass Access for SaaS on Autonomous Database for more information.

Database Links Without a Wallet (TLS)

You can create database links from one Autonomous Database instance to a publicly accessible Autonomous Database without a wallet (TLS).

See Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database without a Wallet (TLS) for more information.

October 2023

Feature Description

Vault Secret Credential Objects

You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required). Supported vaults are:

  • Oracle Cloud Infrastructure Vault
  • Azure Key Vault
  • AWS Secrets Manager
  • GCP Secret Manager

See Use Vault Secret Credentials for more information.

Documentation Addition: Billing Information

Documentation includes summary and detailed Autonomous Database billing information.

See How Is Autonomous Database Billed? for more information.

Documentation Addition: Oracle Database Migration Information

Documentation includes information on migrating your Oracle Database to Autonomous Database.

See Migrate Oracle Databases to Autonomous Database for more information.

ServiceNow Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to ServiceNow. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Invoke Oracle Cloud Infrastructure Functions or AWS Lambda Remote Functions

You can invoke Oracle Cloud Infrastructure Functions and AWS Lambda remote functions in your Autonomous Database as SQL functions.

See Invoke User Defined Functions for more information.

September 2023

Feature Description

Use Select AI to Generate SQL from Natural Language Prompts

Autonomous Database can interact with AI service providers including: OpenAI and CohereAI to provide access to Generative AI capability from Oracle Database that uses Large Language Models (LLMs). One way LLMs can work with Oracle database is by generating SQL from natural language prompts that allow you to talk to your database.

See Use Select AI for Natural Language Interaction with your Database for more information.

Cloud Links Usability and Security

Cloud Links provide a cloud-based method to collaborate between Autonomous Databases. Cloud Links now allow you to set a data set owner. Cloud Links can be configured to require an additional authorization step, where a data set only allows specified databases to access the data set. When you register a data set, you can also specify refreshable clones to offload access to the data set.

See Use Cloud Links for Read Only Data Access on Autonomous Database for more information.

Elastic Pools

Use an elastic pool to consolidate your Autonomous Database instances, in terms of their allocation of compute resources, and to provide up to 87% cost savings.

See Use and Manage Elastic Pools on Autonomous Database for more information.

Free Container Image

Use the Autonomous Database Free Container Image to run Autonomous Database in a container in your own environment, without requiring access to the Oracle Cloud Infrastructure Console or to the internet.

See Use the Autonomous Database Free Container Image for more information.

ECPU-based Databases with Transaction Processing Workload Type Support per-Gigabyte Increments of Storage

You may now provision, clone, and scale using Gigabyte (GB) increments of storage for ECPU-based Autonomous Databases provisioned with the Transaction Processing workload type. The minimum storage allowed for an Autonomous Database instance in ECPU compute model with Transaction Processing workload is 20 GB.

See Provision an Autonomous Database Instance for more information.

Google Analytics Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Use Autonomous Database Oracle-managed heterogeneous connectivity to create database links to Google Analytics. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

August 2023

Feature Description

DBMS_SHARE Package

You can use the subprograms and views in the DBMS_SHARE package to share data with external systems.

See DBMS_SHARE Package for more information.

Logical Partition Change Tracking (LPCT)

Logical Partition Change Tracking enables you to create logical partitions on base tables. It evaluates the staleness of the base tables for individual logical partitions without using a materialized view log or requiring any of the tables used in the materialized view to be partitioned.

Logical Partition Change Tracking provides the capability to leverage the user-supplied logical partitioning information of base tables of materialized view for a more fine-grained, partition-level tracking of stale data for both refresh and rewrite purposes. While classical Partitioning Change Tracking (PCT) relies on the physical partitioning of tables, LPCT has no dependency on tables being physically partitioned; you can use LPCT with both partitioned and nonpartitioned tables.

See Logical Partition Change Tracking and Materialized Views for more information.

Update OCPU to ECPU Compute Model

You can update an Autonomous Database instance from the OCPU billing model to the ECPU billing model.

See Update to ECPU Billing Model on Autonomous Database for more information.

Choose Backup Retention Period with ECPU Compute Model

With the ECPU billing model you have the option to select the backup retention period for automatic backups, with a retention period between 1 day and up to 60 days.

See Edit Automatic Backup Retention Period on Autonomous Database for more information.

AWS Glue Data Catalog Integration

Autonomous Database allows you to synchronize with Amazon Web Services (AWS) Glue Data Catalog metadata. You can query data stored in S3 from Autonomous Database without having to manually derive the schema for the external data sources and create external tables.

See Query External Data with AWS Glue Data Catalog for more information.

July 2023

Feature Description

Track Table Changes with Flashback Time Travel

Use Flashback Time Travel to view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

See Tracking Table Changes with Flashback Time Travel for more information.

Database Actions Quick Links

Database Actions on the Oracle Cloud Infrastructure Console provides quick links to select Database Actions cards or to select the Database Actions Launchpad.

See Access Database Actions as ADMIN for more information.

Object Storage and REST Endpoint Management

DBMS_CLOUD supports a number of preconfigured Object Store and REST endpoints. DBMS_CLOUD also allows you to access additional customer-managed endpoints.

See DBMS_CLOUD Endpoint Management for more information.

detectfieldorder DBMS_CLOUD Format Option

The detectfieldorder format option specifies that the fields in external data files are in a different order than the columns in the table. Specify this option with DBMS_CLOUD.COPY_DATA, DBMS_CLOUD.CREATE_EXTERNAL_TABLE, DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE, or DBMS_CLOUD.CREATE_HYBRID_PART_TABLE to detect the order of fields using the first row of each external data file and map it to the columns of the table.

See DBMS_CLOUD Package Format Options for more information.

Vault Secret Credential Objects

You can create vault secret credentials with secrets stored in Oracle Cloud Infrastructure Vault. You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required).

See Use Vault Secret Credentials for more information.

Export to Directory with DBMS_CLOUD.EXPORT_DATA

Export files as text or as Oracle Data Pump dump files to a directory.

See Export Data to a Directory for more information.

June 2023

Feature Description

Oracle Cloud Infrastructure Signing Key Based Authentication for Oracle Data Pump Import

Oracle Data Pump import using impdp supports credentials created using Oracle Cloud Infrastructure key based attributes.

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

Configurable Automatic Failover Data Loss Limit for a Local Standby Database

For Autonomous Data Guard you can specify an automatic failover data loss limit between 0 and 3600 seconds. Autonomous Data Guard performs automatic failover to a local standby database when a local standby database is available and the system can guarantee either the default zero data loss RPO or up to the data loss limit you specify.

See Automatic Failover with a Standby Database for more information.

Oracle Workspace Manager

Oracle Workspace Manager provides an infrastructure that enables applications to create workspaces and group different versions of table row values in different workspaces. Use Oracle Workspace Manager to version-enable one or more user tables in the database.

See Using Oracle Workspace Manager on Autonomous Database for more information.

Automatic Failover Begin and Automatic Failover End Events

The AutonomousDatabase-AutomaticFailoverBegin and AutonomousDatabase-AutomaticFailoverEnd events are generated when an automatic failover begins and ends. These events are only be triggered if you are using Autonomous Data Guard.

See About Critical Events on Autonomous Database for more information.

Operator Access Event

The OperatorAccess event is generated when operator access is detected for the database.

Autonomous Database operations team never access your data unless you explicitly grant permission through a Service Request for a specified duration.

See Information Events on Autonomous Database for more information.

Built-in Tool Availability Service Level Objective (SLO)

Oracle will use commercially reasonable efforts to have the listed built-in tools meet the Availability objectives as defined in Service Level Objective (SLO) documentation.

See Availability Service Level Objectives (SLOs) for more information.

CMU-AD with Active Directory Servers on a Private Endpoint

There are now two options for configuring Autonomous Database with Centrally Managed Users (CMU) with Microsoft Active Directory:

  • Active Directory (AD) servers publicly accessible: the Active Directory servers are accessible from Autonomous Database through the public internet.

  • Active Directory (AD) servers reside on a private endpoint: the Active Directory servers reside on a private endpoint and are not accessible from Autonomous Database through the public internet.

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

May 2023

Feature Description

Oracle APEX 23.1

Autonomous Database uses Oracle APEX Release 23.1.

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

Google BigQuery Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Autonomous Database support for Oracle-managed heterogeneous connectivity to create database links to Google BigQuery. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Log File Options for DBMS_CLOUD

DBMS_CLOUD provides format parameter options for logging customization: enablelogs, logprefix, logdir, and logretention.

See DBMS_CLOUD Package Format Options for more information.

RESULT_CACHE_MODE Parameter is Modifiable at Session and System Level

Set the RESULT_CACHE_MODE parameter to specify which queries are eligible to store result sets in the result cache. Only query execution plans with the result cache operator will attempt to read from or write to the result cache.

See RESULT_CACHE_MODE for more information.

Stripe Financial Views

Stripe is an online payment processing and credit card processing platform for businesses. The Stripe views allow you to query views created on top of Stripe APIs with DBMS_CLOUD to get Stripe information such as products, invoices, plans, accounts, subscriptions, and customers.

See Stripe Views on Autonomous Database for more information.

Oracle GoldenGate Parallel Replicat (Integrated Mode)

Integrated Parallel Replicat (iPR) supports GoldenGate replication apply for procedural replication, Automatic CDR, and DML handlers.

See Deciding Which Apply Method to Use and About Parallel Replicat for more information.

Persistent Messaging in DBMS_PIPE

The DBMS_PIPE package has extended functionality on Autonomous Database to support persistent messaging, where messages are stored in Cloud Object Store.

See Use Persistent Messaging with Messages Stored in Cloud Object Store for more information.

Access Oracle Cloud Infrastructure Logging Data with Autonomous Database Views

Using the Oracle Cloud Infrastructure Logging Interface you can access log data from an Autonomous Database instance, in relational format. You can query log data in Oracle Cloud Infrastructure across all compartments and regions.

See Oracle Cloud Infrastructure Logging Interface Views for more information.

April 2023

Feature Description

Oracle Spatial Features for Geocoding Address Data and Reverse Geocoding Location Data

Oracle Spatial on Autonomous Database includes features for geocoding address data and for reverse geocoding longitude/latitude data to a street address.

See Using Oracle Spatial with Autonomous Database for more information.

Kerberos Authentication for CMU-AD

You can configure Autonomous Database to use Kerberos authentication for CMU with Microsoft Active Directory users. This configuration allows CMU Active Directory (CMU-AD) users to access an Autonomous Database instance using Kerberos credentials.

User Defined Notification Handler for Scheduler Jobs

Database Scheduler provides an email notification mechanism to track the status of periodically running or automated jobs. In addition to this, the Database Scheduler also supports user-defined PL/SQL Scheduler job notification handler procedure. Adding a scheduler job notification handler procedure allows you to monitor scheduled or automated jobs running in your Autonomous Database.

See User Defined Notification Handler for Scheduler Jobs for more information.

Database Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle Databases on a Private Endpoint

You can create database links from an Autonomous Database to an customer-managed Oracle Database Gateway to access Non-Oracle databases that are on a private endpoint.

See Create Database Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle Databases on a Private Endpoint for more information.

Oracle Machine Learning Notebooks Early Adopter

Oracle Machine Learning Notebooks Early Adopter is an enhanced web-based notebook platform for data engineers, data analyst, R and Python users, and data scientists. You can write code, text, create visualizations, and perform data analytics including machine learning. Notebooks work with interpreters in the back-end. In Oracle Machine Learning, notebooks are available in a project within a workspace, where you can create, edit, delete, copy, move, and even save notebooks as templates.

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

Salesforce Support for Database Links with Oracle-Managed Heterogeneous Connectivity

Autonomous Database support for Oracle-managed heterogeneous connectivity to create database links to Salesforce databases. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Snapshot Standbys for Cross-Region Disaster Recovery

A disaster recovery cross-region peer can be converted to a snapshot standby. This converts either an Autonomous Data Guard cross-region standby database or a cross-region Backup-Based Disaster Recovery peer to a read-write database for up to two days.

See Convert Cross Region Peer to Snapshot Standby for more information.

Singleton Pipe in DBMS_PIPE

Singleton Pipe is an addition to the DBMS_PIPE package that allows you to cache a custom message. Using a Singleton Pipe you can send and retrieve a custom message and share the message across multiple database sessions with concurrent reads.

See Caching Messages with Singleton Pipes for more information.

Migrate Databases Across Regions with Minimal Downtime Using Autonomous Data Guard

You may now terminate, as well as perform all other Primary database actions on a remote Autonomous Data Guard standby when it becomes the Primary database, after a switchover or after a failover. This enables you to use a remote peer for migrating your database to the remote region.

See Using Standby Databases with Autonomous Data Guard for Disaster Recovery for more information.

Send Microsoft Teams Notifications

Use Microsoft Teams notifications. You can send messages, alerts, or the output of a query from Autonomous Database to a Microsoft Teams Channel.

See Send Microsoft Teams Notifications from Autonomous Database for more information.

Send Email Using DBMS_CLOUD_NOTIFICATION

You can send email to a public SMTP endpoint using the Oracle Cloud Infrastructure Email Delivery service.

See Send Email from Autonomous Database Using DBMS_CLOUD_NOTIFICATION for more information.

March 2023

Feature Description

Cloud Links

Cloud Links provide a cloud-based method to collaborate between Autonomous Databases. Using Cloud Links you can access read-only data based on the cloud identities of Autonomous Database instances. The scope of collaboration can be the region where an Autonomous Database resides, individual tenancies, compartments, or particular Autonomous Database instances.

See Using Cloud Links for Read Only Data Access on Autonomous Database for more information.

Backup-Based Disaster Recovery

Backup-Based Disaster Recovery uses backups to instantiate a peer database at the time of switchover or failover. For local Backup-Based Disaster Recovery, existing local backups are utilized and there are no additional costs. Cross-Region Backup-Based Disaster Recovery is also available and incurs additional costs.

See Using Backup-Based Disaster Recovery for more information.

Documentation Addition: Oracle Machine Learning with Autonomous Database

Provides information on options for using Oracle Machine Learning with Autonomous Database.

See Machine Learning with Autonomous Database for more information.

Export Data to Cloud Object Storage as Parquet

Use DBMS_CLOUD.EXPORT_DATA to export data as text. The text format export options are CSV, JSON, Parquet, or XML.

See Export Data to Object Store as Text (CSV, JSON, Parquet, or XML) for more information.

Oracle Real Application Testing Capture and Replay

Use Capture and Replay from one Autonomous Database instance to another Autonomous Database instance. This enables you to compare workloads across different Autonomous Database instances. These Autonomous Database instances may vary at patch levels, database versions, or regions.

See Using Oracle Real Application Testing for more information.

Availability Domain Information

You can obtain tenancy details, including the Availability Domain (AD) for an Autonomous Database instance.

See Obtain Tenancy Details for more information.

Provision an Autonomous Database Instance and Save as Stack

The provisioning option Save as Stack allows you to create and deploy an Autonomous Database instance using Resource Manager.

See Provision Autonomous Database and Overview of Resource Manager for more information.

Oracle Client for Microsoft Tools (OCMT)

Oracle Client for Microsoft Tools (OCMT) is a graphical user interface (GUI) native Microsoft Software installer (MSI) that simplifies ODP.NET setup and provides Autonomous Database connectivity to multiple Microsoft data tools.

See Connect Power BI and Microsoft Data Tools to Autonomous Database for more information.

Long-Term Backups

You can create long-term backups on Autonomous Database with a retention period between three months and up to ten years. When you create a long-term backup you can create a one-time backup or set a schedule to automatically create backups that are taken weekly, monthly, quarterly, or annually (yearly).

See About Backup and Recovery on Autonomous Database and Create Long-Term Backups on Autonomous Database for more information.

Use Directories to Load Data with DBMS_CLOUD Procedures

As an alternative to an object store location URI, you can specify a directory with DBMS_CLOUD procedures to load or unload data from files in a directory, including directories created on attached network file systems.

See Load Data from Directories in Autonomous Database for more information.

February 2023

Feature Description

Maximum Storage Space Metric

The StorageMax metric shows the maximum amount of storage reserved for the database.

See Autonomous Database Metrics and Dimensions for more information.

Oracle Cloud Infrastructure Vault Secret for ADMIN Password

When you create or clone an Autonomous Database instance or when you reset the ADMIN password, you can use an Oracle Cloud Infrastructure vault secret to specify the ADMIN password.

See Use Oracle Cloud Infrastructure Vault Secret for ADMIN Password for more information.

Inactive Connections Detected Event

The InactiveConnectionsDetected event is generated when the number of inactive database connections detected is above a certain ratio, compared to all database connections for the Autonomous Database instance. Subscribing to this event can help you keep track of unused connections.

See About Information Events on Autonomous Database for more information.

Enable Automatic Time Zone File Updates

Autonomous Database lets you choose to enable the feature that automatically updates time zone files on your Autonomous Database instance.

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

Database Relocate and Failed Logon Events

The FailedLoginWarning event is generated when the number of failed login attempts reaches 3 * number of total users in the last three (3) hours.

The InstanceRelocateBegin and InstanceRelocateEnd events are triggered when an Autonomous Database instance is relocated to another Exadata infrastructure due to server maintenance, hardware refresh, a hardware issue, or as part of a resource scale up.

See About Critical Events on Autonomous Database for more information.

January 2023

Feature Description
ECPU Compute Model

Autonomous Database offers two compute models when you create or clone an instance: ECPU and OCPU.

See Compute Models in Autonomous Database for more information.

Configure Built-in Tools

Autonomous Database includes built-in tools that you can enable and disable when you provision or clone a database, or at any time for an existing database.

See Managing Autonomous Database Built-in Tools for more information.

Configure a Custom Private IP Address for a Private Endpoint

You can configure a private endpoint when you provision or clone an Autonomous Database instance, or if your instance is configured to use a public endpoint you can change the configuration to use a private endpoint. Optionally when you configure a private endpoint you can enter a custom private IP address. Providing a custom IP address allows you to preserve an existing private IP address when you migrate from another system.

See Configure Private Endpoints for more information.

Cross-Region Clone from Backup

Autonomous Database provides the option to create a clone in another region when you are cloning a database and you select Clone from a backup. In this case, you choose your preferred region to select the region where you want to create the clone.

See Clone an Autonomous Database from a Backup for more information.

Send Slack Notifications

You can send slack notifications from Autonomous Database. This allows you to send messages to a Slack channel or send the results of a query to a Slack channel.

See Send Slack Notifications from Autonomous Database for more information.

2022 What's New

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2022.

December 2022

Feature Description

Data Pipelines for Loading and Exporting

Data pipelines allow you to repeatedly load data from object store, or export data to object store.

Load pipelines provide continuous incremental data loading from external sources (as data arrives on object store it is loaded to a database table). Export pipelines provide continuous incremental data exporting to object store (as new data appears in a database table it is exported to object store).

See Using Data Pipelines for Continuous Load and Export for more information.

Credential Objects for use with UTL_HTTP, UTL_SMTP, and DBMS_LDAP

You can use credential objects to set authentication for use with UTL_HTTP, UTL_SMTP or DBMS_LDAP.

See Use Credential Objects to set SMTP Authentication, Use Credential Objects to Set HTTP Authentication, and PL/SQL Packages for more information.

Medium and High Service Limits with Auto Scaling

The number of concurrent statements for the high and medium services increases by three times when OCPU Auto Scaling is enabled.

See Service Concurrency for more information.

Multiple Data Catalog Support

Instead of each Autonomous Database instance supporting a single connection to a Data Catalog instance, this feature allows connections to multiple Data Catalog instances.

See About Querying with Data Catalog for more information.

November 2022

Feature Description

Cloud Code Repository Branch Management and Schema Export and Install

Additions and improvements for Cloud Code Repository in the DBMS_CLOUD_REPO package for (Git) repository branch management and schema export and install.

See Using and Managing a Cloud Code Repository with Autonomous Database for more information.

Log File Prefix and Retention Format Options for COPY_DATA

DBMS_CLOUD.COPY_DATA supports the format parameter options: logretention and logprefix.

See DBMS_CLOUD Package Format Options for more information.

Cross-Region Autonomous Data Guard: Remove Second Hostname from Database Connection Strings

The wallet.zip and the connection strings provided for a database with cross-region Autonomous Data Guard enabled no longer contain both the primary and standby database hostnames in a single connection string or wallet.

To avoid connection retry delays and optimize your disaster recovery setup, it is recommended to use the Primary database wallet or connection string to connect to the Primary database, and the remote database wallet or connection string to connect to the remote database (when the remote database is Available to connect to, after a switchover or failover).

See Cross-Region Autonomous Data Guard Connection Strings and Wallets for more information.

Data Transforms in Database Actions

Data Transforms is a built-in data integration tool and is accessible from Database Actions. Data Transforms is a simple-to-use, drag-and-drop, no-code tool to load and transform data from heterogeneous sources to Autonomous Database. Use Data Transforms for all data integration needs such as building data warehouses and feeding analytics applications.

See The Data Transforms Page for more information.

Access Network File System (NFS) Directories

You can attach a Network File System to a directory location in your Autonomous Database. This allows you to load data from Oracle Cloud Infrastructure File Storage in your Virtual Cloud Network (VCN) or from any other Network File System in on-premises data centers.

See Access Network File System from Autonomous Database for more information.

Customer Managed Keys with Cross-Region Autonomous Data Guard

Autonomous Database fully supports using customer-managed keys with a remote standby database with Autonomous Data Guard.

See Autonomous Data Guard with Customer Managed Keys and Notes for Customer-Managed Keys with Autonomous Data Guard for more information.

Cross-Region Refreshable Clones

Create one or more clones in regions other than the region of your primary (source) database. Clones in remote regions can be refreshed from the source database.

See Using Refreshable Clones with Autonomous Database for more information.

Use Text Index to Query Text on Object Storage

You can build an Oracle Text index on object store files. This allows you to search the object store for text and use wildcards with your search.

See Query Text in Object Storage for more information.

Documentation Addition: Data Lake Capabilities with Autonomous Database

A new section provides information on using Autonomous Database as a data lakehouse.

See Using Data Lake Capabilities with Autonomous Database for more information.

Bulk Operations for Files in the Cloud

The PL/SQL package DBMS_CLOUD offers parallel execution support for bulk file upload, download, copy, and transfer activities, which streamlines the user experience and delivers optimal performance for bulk file operations.

See Bulk Operations for Files in the Cloud for more information.

October 2022

Feature Description

Clone from Backup Select Latest Available Timestamp Option

When you clone an Autonomous Database instance you can select clone from latest backup. This option selects the latest available backup timestamp as the clone source. You can select this option if a database becomes unavailable and you want to create a clone, or for any reason when you want to create a clone based on the most recent backup.

See Clone Autonomous Database from a Backup for more information.

Use Customer-Managed Encryption Keys Located in a Different Tenancy

You can use customer-managed master encryption keys with the Vault and Keys in a different tenancy. The Vault and the Autonomous Database instance can be in a different tenancy, but they must be in the same region.

See Use Customer-Managed Encryption Key Located in a Remote Tenancy for more information.

Use Google Service Account to Access GCP Resources

You can use a Google service account to access Google Cloud Platform (GCP) resources from an Autonomous Database instance.

See Use Google Service Account to Access Google Cloud Platform Resources for more information.

SYSDATE_AT_DBTIMEZONE Parameter is Modifiable at Session and System Level

Depending on the value of SYSDATE_AT_DBTIMEZONE, you see either the date and time based on the default Autonomous Database time zone, Coordinated Universal Time ‎(UTC)‎, or based on the time zone that you set in your database.

See SYSDATE_AT_DBTIMEZONE for more information.

View Oracle Cloud Operations Actions

The DBA_OPERATOR_ACCESS view stores information on the actions that Oracle Cloud Infrastructure cloud operations performs on your Autonomous Database. This view will not show results if Oracle Cloud Infrastructure cloud operations hasn't performed any actions or run any statements in your Autonomous Database instance.

See View Oracle Cloud Infrastructure Operations Actions for more information.

September 2022

Feature Description

Expanded list of Databases with Oracle-Managed Heterogeneous Connectivity

Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to non-Oracle databases. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection to the non-Oracle database.

The list of supported non-Oracle databases is expanded to include Hive and MongoDB.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Oracle APEX Upgrade Events

The APEXUpgradeBegin and APEXUpgradeEnd events are generated when you are using Oracle APEX and your Autonomous Database instance begins an upgrade or completes an upgrade to a new Oracle APEX release.

See About Events Based Notification and Automation on Autonomous Database for more information.

Oracle MTS (OraMTS) Recovery Service

Use Oracle MTS (OraMTS) Recovery Service to resolve in-doubt Microsoft Transaction Server transactions on Autonomous Database.

See Using OraMTS Recovery Feature on Autonomous Database for more information.

August 2022

Feature Description

Documentation Addition: Updated Python Connection Information

You can connect Python applications to your Autonomous Database instance either with a wallet (mTLS) or without a wallet (TLS), using the python-oracledb driver.

See Connect Python Applications to Autonomous Database for more information.

Autonomous Data Guard SLA

Autonomous Database provides a higher 99.995% availability SLA service commitment with Autonomous Data Guard enabled with a standby database.

Database availability SLA is calculated based on the "Monthly Uptime Percentage" described in the Oracle PaaS and IaaS Public Cloud Services Pillar Document, document under Delivery Policies.

Oracle Machine Learning for R (OML4R)

Oracle Machine Learning for R (OML4R) is a component of the Oracle Machine Learning family of products, which integrates R with Autonomous Database.

Use Oracle Machine Learning for R to:

  • Perform data exploration and data preparation while seamlessly leveraging Oracle Database as a high-performance computing environment.
  • Run user-defined R functions on database spawned and controlled R engines, with system-supported data-parallel and task-parallel capabilities.
  • Access and use powerful in-database machine learning algorithms from R language.

See About Oracle Machine Learning for R for more information.

Synchronization with Data Catalog Enhancements

Use the DBMS_DCAT$SYNC_LOG view to easily access the log for the latest Data Catalog synchronization execution.

See DBMS_DCAT SYNC_LOG View for more information.

Regional Availability Metrics

You can view regional availability metrics by data center for Oracle Autonomous Database.

See Monitor Regional Availability of Autonomous Databases for more information.

July 2022

Feature Description

Use Oracle Java

Autonomous Database supports Oracle JVM. Oracle JVM is a standard, Java-compatible environment that runs any pure Java application.

See Using Oracle Java on Autonomous Database for more information.

Oracle APEX 22.1

Autonomous Database uses Oracle APEX Release 22.1.

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

Wallet Rotation with a Grace Period

Autonomous Database allows you to rotate wallets for an Autonomous Database instance or for all instances that a cloud account owns in a region, with a grace period of 1 hour to 24 hours.

See Rotate Wallets for Autonomous Database for more information.

Change Display Name

You can change the display name for an Autonomous Database instance.

See Update the Display Name for an Autonomous Database Instance for more information.

Default Database Name

The default database name and the matching default display name supplied when you provision or clone an instance is a generated 16-character string.

See Provision Autonomous Database and Clone an Autonomous Database Instance for more information.

Oracle Real Application Testing: Database Replay

You can use Oracle Real Application Testing Database Replay to capture workload from an on-premises or other cloud service database and replay it on an Autonomous Database instance. This enables you to compare workloads between an on-premises database or other cloud service database and an Autonomous Database.

See Using Oracle Real Application Testing - Database Replay for more information.

Export Data with Column Names in Header Row

You can optionally write column names as the first line in output files when you use the EXPORT_DATA procedure with CSV output.

See EXPORT_DATA Procedure and DBMS_CLOUD Package Format Options for EXPORT_DATA with Text Files (CSV, JSON, and XML for more information.

June 2022

Feature Description

Character Set Support

The Autonomous Database default database character set is Unicode AL32UTF8 and the default national character set is AL16UTF16. When you provision a database, depending on the workload type, you can select a database character set and a national character set.

See Choose a Character Set for Autonomous Database for more information.

Support for Oracle LogMiner

Autonomous Database supports using Oracle LogMiner.

See Oracle LogMiner for more information.

Synchronization with Data Catalog Enhancements

Synchronize Data Catalog partitioned metadata with Autonomous Database to create partitioned external tables. See the DBMS_DCAT RUN_SYNC procedure.

Database Actions Changes

Database Actions includes new features.

See Changes in Oracle Database Actions for more information.

Network Security Group (NSG) Configuration with Private Endpoint

For a private endpoint, the incoming and outgoing connections are limited by the combination of ingress and egress rules defined in NSGs and in the Security Lists associated with the private endpoint's VCN. Adding an NSG is now optional; when you do not include an NSG the ingress and egress rules defined in the Security Lists for the VCN still apply.

See Configuring Network Access with Private Endpoints for more information.

Simplified Configuration Steps with CMU for Microsoft Active Directory

You can configure Autonomous Database to authenticate and authorize Microsoft Active Directory users. The configuration steps are simplified for enabling Autonomous Database with Centrally Managed Users (CMU).

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

May 2022

Feature Description

Azure Active Directory (Azure AD ) Integration

Azure Active Directory (Azure AD ) users can connect to an Autonomous Database instance using Azure OAuth2 access tokens.

See Use Azure Active Directory (Azure AD) with Autonomous Database for more information.

OCPU Limit for License Type Bring Your Own License (BYOL)

The license type Bring Your Own License (BYOL), Oracle Database Standard Edition sets the maximum number of OCPUs that you can use to 8.

See View and Update Your License and Oracle Database Edition on Autonomous Database for more information.

Kerberos Authentication Support

You can use Kerberos to authenticate Autonomous Database users.

See Configure Kerberos Authentication for more information.

Autonomous Data Guard Standby State

Autonomous Data Guard shows a standby database in "Standby" state.

See Autonomous Database Standby Database State for more information.

Database Actions Additions

Database Actions provides all the functionality that is available on the Autonomous Database Service Console. The Service Console will be deprecated soon.

See Service Console Replacement with Database Actions for more information on where to find Service Console functionality in Database Actions.

Autonomous Data Guard Support for Terraform

Autonomous Data Guard supports operation from Terraform scripts

See the following for more information:

Use Azure Service Principal

You can use an Azure service principal with Autonomous Database to access Azure resources without having to create and store your own credential objects in the database.

See Use Azure Service Principal to Access Azure Resources for more information.

Monitor Autonomous Database Availability

You can monitor availability information for your Autonomous Database instance form the Oracle Cloud Infrastructure Console or by viewing metrics.

See Monitor Autonomous Database Availability and View Metrics for an Autonomous Database Instance for more information.

Database Names Length Limit

The length limit for database names when you create or clone your database has been increased from 14 to 30 characters. This change provides more flexibility, giving you the option to create longer database names.

See Provision Autonomous Database or Clone an Autonomous Database Instance for more information.

Egress Rules for all Outbound Connections with Private Endpoints

When you define a private endpoint for your Autonomous Database instance you can provide enhanced security by setting a database property to enforce that all outgoing connections to a target host are subject to and limited by the private endpoint's egress rules.

See Enhanced Security for Outbound Connections with Private Endpoints for more information.

April 2022

Feature Description

Display Autonomous Database Availability

You can monitor Autonomous Database availability from the Oracle Cloud Infrastructure Console or using metrics.

See Monitor Autonomous Database Availability for more information.

OML4Py SQL API for Embedded Python Execution

OML4Py embedded Python execution on Autonomous Database supports a SQL API in addition to the REST API. Embedded execution allows you to run user-defined Python functions in database-spawned and managed Python engines, along with data-parallel and task-parallel automation.

See SQL API for Embedded Python Execution with On-premises Database for more information.

Create Database Links from Autonomous Database to Oracle Databases on a Private Endpoint without a Wallet

You can create database links from an Autonomous Database to a target Oracle Database that is on a private endpoint and connect without a wallet (TCP).

See Create Database Links from Autonomous Database to Oracle Databases on a Private Endpoint without a Wallet for more information.

Availability Service Level Objectives (SLOs)

Describes the Service Level Objectives (SLOs) for Oracle Autonomous Database.

See Availability Service Level Objectives (SLOs) for more information.

Synchronization with Data Catalog Enhancements

The DBMS_DCAT RUN_SYNC procedure has new parameters to give you more control over what objects are synchronized and how the synchronization is performed.

See CREATE_SYNC_JOB Procedure and RUN_SYNC Procedure for more information.

Data Catalog Views

Discover all accessible data catalogs in the current region or across all regions.

See ALL_DCAT_GLOBAL_ACCESSIBLE_CATALOGS View and ALL_DCAT_LOCAL_ACCESSIBLE_CATALOGS View for more information.

March 2022

Feature Description

Oracle APEX 21.2

Autonomous Database uses Oracle APEX Release 21.2.

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

OML4Py Client Access

A new client package for OML4Py provides a “universal" client in that users can access Autonomous Database from a standalone Python engine on Linux to connect to Autonomous Database as well as 19c and newer Oracle Database releases. This supports working with OML4Py on Autonomous Database, local third-party IDEs, and other notebook environments, like JupyterLab. It further allows switching between on-premises and Autonomous Database instances using the same client package.

See Install OML4Py Client for Linux for Use With Autonomous Database for more information.

Oracle APEX Upgrade Available Event

The APEXUpgradeAvailable event is generated when you are using Oracle APEX and a new release becomes available.

See About Events Based Notification and Automation on Autonomous Database for more information.

Database Links with Oracle-Managed Heterogeneous Connectivity

Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to non-Oracle databases. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection to the non-Oracle database.

See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information.

Metadata Columns in External Tables

To identify which file each row is coming from in your external tables, you can query the columns named file$name and file$path to find the source file name and the Object Store path URL for that file.

See External Table Metadata Columns for more information.

External Tables with Partitioning Specified in Source Files

When you use external file partitioning with the partitions specified in external source files, Autonomous Database analyzes Cloud Object Store path information to determine the partition columns and data types.

See Query External Tables with Partitioning Specified in Source Files for more information.

Identity and Access Management (IAM) Authentication Additional Features

You can configure Autonomous Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous Database with IAM credentials. New additions for IAM support include the following: defining global user mapping, defining global roles mapping, support for resource principal usage with IAM, and proxy user support.

See Use Identity and Access Management (IAM) Authentication with Autonomous Database for more information.

Storage Auto Scaling

With Storage auto scaling enabled the Autonomous Database can expand to use up to three times the reserved base storage. If you need additional storage, the database automatically uses the reserved storage without any manual intervention required. Storage auto scaling is disabled by default.

See Storage Auto Scaling for more information.

Documentation Addition: Get Help, Search Forums, and Contact Support

When you use Autonomous Database, sometimes you need to get help from the community or to talk to someone in Oracle support. This documentation addition provides information about getting help by viewing and posting questions on forums and using Oracle Cloud Support to create a support request.

See Get Help, Search Forums, and Contact Support for more information.

February 2022

Feature Description

Track Oracle Cloud Infrastructure Resources, Cost and Usage

Autonomous Database provides details on Oracle Cloud Infrastructure resources, cost and usage.

See Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous Database Views for more information.

Critical Events with Customer-Managed Keys

Autonomous Database events are triggered when an instance is using customer-managed keys and the database becomes inaccessible or when the database recovers from being inaccessible.

See About Critical Events on Autonomous Database for more information.

Time Zone Handling in Calls to SYSDATE and SYSTIMESTAMP

The initialization parameter SYSDATE_AT_DBTIMEZONE parameter enables special handling in a session for the date and time value returned in calls to SYSDATE and SYSTIMESTAMP. Depending on the value of SYSDATE_AT_DBTIMEZONE, you see either the date and time based on the default Autonomous Database time zone, Coordinated Universal Time ‎(UTC)‎, or based on the time zone that you set in your database.

See SYSDATE_AT_DBTIMEZONE for more information.

January 2022

Feature Description

Use a Cloud Code Repository

Autonomous Database provides routines to manage and store files in Cloud Code (Git) Repositories. The supported Cloud Code Repositories are: GitHub Repository, AWS CodeCommit, and Azure Repos.

See Using and Managing a Cloud Code Repository with Autonomous Database for more information.

Oracle Machine Learning Notebooks Repository

Oracle Machine Learning Notebooks repositories are stored in a schema on the Autonomous Database instance. This enables database instance-specific backup and restore of Oracle Machine Learning Notebooks as well as support for cross-region Autonomous Data Guard.

See What's New in Oracle Machine Learning on Autonomous Database for more information.

Oracle Machine Learning Notebooks Import and Export of Jupyter Format Notebooks

Oracle Machine Learning Notebooks supports importing and exporting Jupyter format notebooks. This makes it easier for users to interoperate with other notebook environments.

See Export a Notebook and Import a Notebook for more information.

Add My IP Address Button

When you provision an Autonomous Database instance and configure network access with Access Control Lists (ACLs) or when you update network access, click Add My IP Address to add your current IP address to the ACL entry.

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

Reconnect a Disconnected Refreshable Clone

You can reconnect a refreshable clone to the source database. This allows you to use a refreshable clone as a test database and run DML and make changes while the database is disconnected. When you are done with your testing you can reconnect to the source database, which refreshes the clone to the point where it was when you disconnected.

See Reconnect a Refreshable Clone to the Source Database for more information.

GitHub Raw URL support in DBMS_CLOUD

Use GitHub Raw URLs with DBMS_CLOUD APIs to access source files that reside on a GitHub Repository.

See GitHub Raw URL Format for more information.

View Maintenance Status and Timezone Version Notifications

The DB_NOTIFICATIONS view stores information about maintenance status notifications and timezone version upgrade notifications for your Autonomous Database instance.

See View Maintenance Status and Timezone Version Notifications for more information.

One-way TLS Connections on Linux x64 Clients using Oracle Call Interface without a Wallet

Using TLS authentication for Oracle Call Interface connections on Linux x64, a wallet is not required when the client program connects with Oracle Instant Client 19.13. Using TLS authentication for Oracle Call Interface connections on all other platforms, or without Oracle Instant Client 19.13, clients must provide a generic CA root certificate wallet.

See Prepare for Oracle Call Interface, ODBC, and JDBC OCI Connections Using TLS Authentication for more information.

2021 What's New

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2021.

December 2021

Feature Description

Oracle Database API for MongoDB

Oracle Database API for MongoDB lets applications interact with collections of JSON documents in Autonomous Database using MongoDB commands.

See Using Oracle Database API for MongoDB for more information.

Oracle Data Miner Access to Autonomous Database

Oracle Data Miner in SQL Developer can be used with Oracle Autonomous Database. Oracle Data Miner is a SQL Developer extension that enables users to create, schedule, and deploy analytical workflows through a drag-and-drop user interface. Oracle Data Miner serves as a productivity tool for data scientists and an enabler for citizen data scientists with a no-code machine learning environment that automates some common machine learning steps.

See Oracle Data Miner for more information.

Autonomous Data Guard Paired Regions

The Autonomous Data Guard paired region list is expanded with additional regions. Autonomous Data Guard paired regions are remote regions where you can create a cross-region standby database.

See Autonomous Data Guard Paired Regions for more information.

DBMS_PIPE PL/SQL Package

The DBMS_PIPE package that lets two or more sessions in the same instance communicate is available in Autonomous Database.

Cross-Region Cloning

When you clone an Autonomous Database instance using the Oracle Cloud Infrastructure Console, you can select your preferred region for the clone. You can create the clone in the current region or in a remote region. The list of available regions to create a clone only shows the regions that you are subscribed to.

See Clone an Autonomous Database Instance for more information.

Identity and Access Management (IAM) Authentication

You can configure Autonomous Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous Database with IAM credentials.

See Use Identity and Access Management (IAM) Authentication with Autonomous Database for more information.

Schedule Start and Stop Times

When you enable an Auto Start/Stop Schedule for an Autonomous Database instance, the instance automatically starts and stops according to the schedule you specify. This allows you to reduce costs by scheduling shutdown periods for times when a system is not in use.

See Schedule Start and Stop Times for an Autonomous Database Instance for more information.

PL/SQL API for Switching Consumer Groups

Use the CS_SESSION Package to switch the database service and consumer group of an existing session.

See CS_SESSION Package for more information.

Export Data as CSV, JSON, or XML Data Files

You can export data from Autonomous Database as text in the following formats: CSV, JSON, or XML.

See Move Data to Object Store as CSV, JSON, or XML Using EXPORT_DATA for more information.

Use Database Links with a Target Database on a Private Endpoint

Create database links from an Autonomous Database source to a target Oracle Database that is on a private endpoint. To create a database link to a target database on a private endpoint, the target database must be accessible from the source database's Oracle Cloud Infrastructure VCN.

See Create Database Links from Autonomous Database to Oracle Databases on a Private Endpoint for more information.

November 2021

Feature Description

Database Management

The Associated Services area on the Oracle Cloud Infrastructure Console includes a Database Management link. You can use Database Management service to monitor the health of a single Autonomous Database or a fleet of Autonomous Databases.

See Use Database Management Service to Monitor Databases for more information.

Database Actions Access

Access Database Actions on the Oracle Cloud Infrastructure Console with Database Actions button.

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

DBMS_LDAP and UTL_TCP Packages

The DBMS_LDAP and UTL_TCP packages are available, with some restrictions.

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

Concurrent Operations with Lifecycle Management Actions

When you initiate operations that take some time to complete, including scaling the system (Scale Up/Down), these operations no longer prevent you from performing other operations. For example, if you perform certain database lifecycle management actions such as stopping the database during a long-running operation, depending on the operation, the long running operation is either canceled or paused.

See Concurrent Operations on Autonomous Database for more information.

October 2021

Feature Description

Import JSON Data from Cloud Object Store

You can import JSON data from Cloud Object Store into a table.

This import method supports all the Cloud Object Stores supported by Autonomous Database, and you can use an Oracle Cloud Infrastructure resource principal to access your Oracle Cloud Infrastructure Object Store or Amazon Resource Names (ARNs) to access AWS Simple Storage Service (S3).

See Create Credentials and Copy JSON Data into an Existing Table for more information.

Blockchain Tables Support

Blockchain tables are insert-only tables that organize rows into a number of chains. Blockchain tables protect data that records important actions, assets, entities, and documents from unauthorized modification or deletion by criminals, hackers, and fraud. Blockchain tables prevent unauthorized changes made using the database and detect unauthorized changes that bypass the database.

See Managing Blockchain Tables for more information.

Immutable Tables Support

Immutable tables are read-only tables that prevent unauthorized data modifications by insiders and accidental data modifications resulting from human errors.

See Managing Immutable Tables for more information.

Integrate with Oracle Cloud Infrastructure Data Catalog

OCI Data Catalog metadata is synchronized with Autonomous Database creating schemas and external tables. You are allowed to immediately query data available in object store.

See Query External Data with Data Catalog for more information.

Oracle APEX 21.1

Autonomous Database uses Oracle APEX Release 21.1.

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

September 2021

Feature Description

TLS and Mutual TLS Connections

Autonomous Database by default supports Mutual TLS (mTLS) connections. You have the option to configure an Autonomous Database instance to support both mTLS and TLS connections.

See the following for more information:

Vanity URLs for APEX, ORDS and Database Tools

You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS), and developer tools by placing an Oracle Cloud Infrastructure Load Balancer directly in front of your Autonomous Database.

See the following for additional details, including prerequisites and step-by-step instructions:

August 2021

Feature Description

Cross-Region Autonomous Data Guard

Autonomous Data Guard allows you to enable a cross-region standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance.

When you enable Autonomous Data Guard, the system creates a standby database that is continuously updated with the changes from the primary database. You can enable Autonomous Data Guard with a standby in the current region, a local standby, or with a standby in a different region, a cross-region standby. You can also enable Autonomous Data Guard with both a local standby and a cross-region standby.

See Using Standby Databases with Autonomous Database for Disaster Recovery for more information.

SQL Tracing for Database Session

Use SQL tracing to help you identify the source of an excessive database workload, such as a high load SQL statement in your application.

See Perform SQL Tracing on Autonomous Database for more information.

Export Data as JSON to Cloud Object Store

Use the procedure DBMS_CLOUD.EXPORT_DATA to export data to your Cloud Object Store as JSON, by specifying a query.

This export method supports all the Cloud Object Stores supported by Autonomous Database, and you can use an Oracle Cloud Infrastructure resource principal to access your Oracle Cloud Infrastructure Object Store or Amazon Resource Names (ARNs) to access AWS Simple Storage Service (S3).

See Move Data to Object Store as JSON Data Using EXPORT_DATA for more information.

Documentation Addition: Load Data from a Source File with Fixed Width Data

The documentation provides an example for loading data from a fixed-width source file to an external table.

See Example Loading Data from a Fixed Width File for more information.

Set Patch Level

When you provision or clone an Autonomous Database instance you can select a patch level to apply upcoming patches. There are two patch level options: Regular and Early.

After your provision or clone an Autonomous Database instance and set the patch level to Early, maintenance windows for the instance are scheduled and applied one week before instances with the patch level set to Regular. The Early patch level allows you to use and to test upcoming patches before they are applied to all systems.

See Set the Patch Level for more information.

July 2021

Feature Description

View Patch Details

You can view Autonomous Database patch information, including a list of resolved issues.

See View Patch Information for more information.

Include Developer Tools Links in Wallet Readme File

The wallet README file includes links for Autonomous Database tools and resources, including: Database Actions, Graph Studio, Oracle APEX, Oracle Machine Learning Notebooks, Autonomous Database Service Console, and SODA drivers.

See Wallet README File for more information.

June 2021

Feature Description

Change MEDIUM Service Concurrency Limit from Service Console

If your application requires a customized concurrency limit not available with the predefined services, you can modify the concurrency limit for the MEDIUM service from the Autonomous Database Service Console or using PL/SQL procedures.

See Change MEDIUM Service Concurrency Limit for more information.

Automatic Partitioning

Automatic partitioning analyzes and automates partition creation for tables and indexes of a specified schema to improve performance and manageability in Autonomous Database. Automatic partitioning, when applied, is transparent and does not require user interaction or maintenance. Automatic partitioning does not interfere with existing partitioning strategies and manually partitioned tables are excluded as candidates for automatic partitioning.

See Manage Automatic Partitioning on Autonomous Database for more information.

Use Customer-Managed Encryption Keys

Autonomous Database provides two options for Transparent Data Encryption (TDE) to encrypt data in the database:

  • Oracle-managed encryption keys
  • Customer-managed encryption keys

See Managing Encryption Keys on Autonomous Database for more information.

Autonomous Database RMAN Recovery Catalog

You can use Autonomous Database as a Recovery Manager (RMAN) recovery catalog. A recovery catalog is a database schema that RMAN uses to store metadata about one or more Oracle databases.

See Autonomous Database RMAN Recovery Catalog for more information.

Read-Only Mode for Sessions

You can set the Autonomous Database operation mode to read-only for a session. In read-only mode users for the session can only run queries.

See Change Autonomous Database Operation Mode for a Session for more information.

Documentation Addition: CS_RESOURCE_MANAGER Package

The CS_RESOURCE_MANAGER package provides procedures to list and update consumer group parameters, and to revert parameters to default values.

See CS_RESOURCE_MANAGER Package for more information.

May 2021

Feature Description

Transparent Application Continuity (TAC) on Autonomous Database

Autonomous Database provides application continuity features for making connections to the database. You enable Application Continuity on Autonomous Database in one of two configurations: Application Continuity(AC) or Transparent Application Continuity (TAC).

Application Continuity hides outages for thin Java-based applications, Oracle Database Oracle Call Interface, and ODP.NET based applications with support for open-source drivers, such as Node.js, and Python.

Transparent Application Continuity (TAC) transparently tracks and records session and transactional state so the database session can be recovered following recoverable outages. This is done with no reliance on application knowledge or application code changes.

See Using Application Continuity on Autonomous Database for more information.

Amazon Resource Names (ARNs) to Access AWS Resources

You can use Amazon Resource Names (ARNs) to access AWS resources with Autonomous Database. When you use ARN role based authentication with Autonomous Database, you can securely access AWS resources without creating and saving credentials based on long-term AWS IAM access keys.

See Use Amazon Resource Names (ARNs) to Access AWS Resources for more information.

Resource Principal to Access Oracle Cloud Infrastructure Resources

When you use a resource principal with Autonomous Database, you or your tenancy administrator define the Oracle Cloud Infrastructure policies in a dynamic group that allows you to access resources. With a resource principal you do not need to create a credential object and Autonomous Database creates and secures the resource principal credentials you use to access the Oracle Cloud Infrastructure resources specified in the dynamic group.

See Use Resource Principal to Access Oracle Cloud Infrastructure Resources for more information.

Graph Studio

Graph Studio features include automated modeling to create graphs from database tables, an integrated notebook to run graph queries and analytics, and native graph and other visualizations. You can invoke nearly 60 pre-built graph algorithms and visualize your data with many visualization options. Graph Studio is a fully integrated, automated feature with Autonomous Database.

See Using Oracle Graph with Autonomous Database for more information.

April 2021

Feature Description

Change MEDIUM Service Concurrency Limit

If your application requires a customized concurrency limit not available with the predefined services, you can modify the concurrency limit for the MEDIUM service.

See Change MEDIUM Service Concurrency Limit for more information.

DBMS_CLOUD REST API Results Cache

The DBMS_CLOUD REST API functions allow you to make HTTP requests and obtain and save results. Saving results in the cache allows you to view past results with the SESSION_CLOUD_API_RESULTS view. Saving and querying historical results of DBMS_CLOUD REST API requests can help you when you need to work with previous results in your applications.

See DBMS_CLOUD REST API Results Cache for more information.

View and Manage Customer Contacts for Operational Issues and Announcements

When customer contacts are set, Oracle sends notifications to the specified email addresses to inform you of service-related issues. Contacts in the customer contacts list receive unplanned maintenance notices and other notices, including but not limited to notices for database upgrades and upcoming wallet expiration.

See View and Manage Customer Contacts for Operational Issues and Announcements for more information.

Always Free Autonomous JSON Database

You have the option to create a limited number of Always Free Autonomous JSON Databases that do not consume cloud credits. Always Free Autonomous JSON 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.

Always Free Oracle APEX Application Development

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

See Always Free Oracle APEX Application Development for more information.

Expiring Wallets Notification

Starting six weeks before the wallet expiration date Oracle sends notification emails each week, indicating the wallet expiration date. These emails provide notice before your wallet expires that you need to download a new wallet. You can also use the WalletExpirationWarning event to be notified when a wallet is due to expire.

See Download Client Credentials (Wallets) for more information.

Documentation Addition: Oracle Graph

Oracle Graph with Autonomous Database enables you to create graphs from data in your Autonomous Database. With graphs you can analyze your data based on connections and relationships between data entities.

See Using Oracle Graph with Autonomous Database for more information.

Documentation Addition: Oracle Spatial

Oracle Spatial with Autonomous Database allows developers and analysts to get started easily with location intelligence analytics and mapping services.

See Using Oracle Spatial with Autonomous Database for more information.

Download Data Pump Dump File Set with Script

To support using Oracle Data Pump Import to import a dump file set to a target database, you can use a script that supports substitution characters to download all the dump files from your Object Store in a single command.

See Download Dump Files, Run Data Pump Import, and Clean Up Object Store for more information.

March 2021

Feature Description

Autonomous Database Tools for Database Actions

Autonomous Database provides the following data tools:

  • Data Load: helps you select data to load from your local computer, from tables in other databases, or from cloud storage. Then you can add the data you select to new or existing tables or views in Autonomous Database.

    See The Data Load Page for more information.

  • Catalog: helps you to see information about the entities in your Autonomous Database, and to see the effect that changing an object has on other objects. Catalog provides a tool for you to examine data lineage and understand the impact of changes.

    See The Catalog Page for more information.

  • Data Insights: crawls a table or business model and discovers hidden patterns, anomalies, and outliers in your data. Insights are automatically generated by built-in analytic functions. The results of the insight analysis appear as bar charts in the Data Insights dashboard.

    See The Data Insights Page for more information.

  • Business Models: describes the business entities that are derived from data in your Autonomous Database schema or from other sources. This allows you to create a semantic model on top of your data identifying hierarchies, measures, and dimensions.

    See The Business Models Page for more information.

Maintenance History

You can view Autonomous Database maintenance history to see details about past maintenance, such as the start time and stop time for past maintenance events.

See About Autonomous Database Maintenance Windows and History for more information.

Oracle Machine Learning AutoML User Interface

AutoML User Interface (AutoML UI) is an Oracle Machine Learning interface that provides you with no-code automated machine learning. When you create and run an experiment in AutoML UI, it automatically performs algorithm and feature selection, as well as model tuning and selection, thereby enhancing productivity as well as model accuracy and performance.

See Get Started with AutoML for more information.

Oracle Machine Learning Models

REST endpoints are available so that you can store Machine Learning models and create scoring endpoints for the models. The REST API for Oracle Machine Learning Services supports both Oracle Machine Learning models and ONNX format models.

See REST API for Oracle Machine Learning Services for more information.

ADMIN Password Expiration Warning Event

The AdminPasswordWarning event produces an event when the Autonomous Database ADMIN password is expiring within 30 days or is expired.

See About Events Based Notification and Automation on Autonomous Database for more information.

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.

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

You can access Oracle APEX, 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

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2020.

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 APEX 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 Database Serverless products.

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 APEX, 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 APEX Release 20.1

Autonomous Database supports Oracle APEX 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 Data to Object Store as Oracle Data Pump Files Using 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 APEX (APEX), RESTful services, and SQL Developer Web.

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

2019 What's New

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2019.

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 APEX (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.

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

SQL Developer Web Data Loading

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

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

Access APEX from Oracle Cloud Infrastructure Console

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

See Access Oracle Application Express Administration Services for more information.

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

See Access SQL Developer Web as ADMIN for more information.

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

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

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

See About Autonomous Database Maintenance Windows for more information.

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

See LIST_FILES Function and LIST_OBJECTS Function for more information.

October 2019

Feature Description
Preview Version for Autonomous Database

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

See Preview Versions for Autonomous Database for more information.

Download database specific instance wallets or regional wallets

You can download database specific instance wallets or regional wallets.

See Download Client Credentials (Wallets) for more information.

Rotate database specific instance wallets or regional wallets

You can rotate database specific instance wallets or regional wallets.

See Rotate Wallets for Autonomous Database for more information.

Create partitioned external tables with DBMS_CLOUD

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

See Query External Partitioned Data for more information.

Numeric Formats

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

See DBMS_CLOUD Package Format Options for more information.

September 2019

Feature Description
Always Free Autonomous Database

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

See Always Free Autonomous Database for more information.

Autonomous Database Metrics

You can monitor the health, capacity, and performance of your 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 APEX (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 APEX; 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.

See Use Auto Scaling for more information.

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

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.

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 Using Application Continuity on Autonomous Database 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

Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2018.

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.

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 password 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 or Azure Data Lake Storage integration

Autonomous Database now supports Microsoft Azure Blob Storage or Azure Data Lake 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.