New Feature Announcements
Announcements for the noteworthy changes made to Autonomous Database on Dedicated Exadata Infrastructure.
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
Parent topic: Overview
October 2024
Feature | Description |
---|---|
Support for regular expressions in DBMS_CLOUD procedures
|
On Autonomous Database on Dedicated Exadata Infrastructure, you can use the
regexuri format option with the following DBMS_CLOUD procedures:
For more information, see DBMS_CLOUD Package Format Options and DBMS_CLOUD Package Format Options for Avro, ORC, or Parquet. |
Support for X10M Base System |
When you create Autonomous Database deployments on Exadata Cloud@Customer, you can deploy to X10M Exadata Database Machine Base system. See Exadata X10M Systems for system specifications. |
Ability to create a cross tenancy Autonomous Data Guard Standby Database |
On Oracle Public Cloud deployments, you can add an Autonomous Data Guard standby database that resides in a tenancy different from the primary database. The cross tenancy standby database can be in the same region or a different region (cross region). A cross tenancy standby database can only be added using the CLI or the Autonomous Database REST APIs. This option is not available using the Oracle Cloud Infrastructure console. See Add a Cross Tenancy Standby Database for instructions. |
Updated Object Storage URL Format using Dedicated Endpoints for commercial (OC1) realms |
Autonomous Database on Dedicated Exadata Infrastructure supports Oracle Cloud Infrastructure Object Storage URI formats for commercial (OC1) realms. See Cloud Object Store URI Formats for more information. |
Configure Zero Trust Packet Routing (ZPR) for Autonomous Database on Dedicated Exadata Infrastructure deployments on Oracle Public Cloud. |
Oracle Cloud Infrastructure Zero Trust Packet Routing (ZPR) protects sensitive data from unauthorized access through intent-based security policies you write for resources, such as an Autonomous Exadata VM Cluster (AVMC) to which you assign security attributes. Security attributes are labels that ZPR uses to identify and organize resources. ZPR enforces policy at the network level each time access is requested, regardless of potential network architecture changes or misconfigurations. ZPR is built on the existing network security group (NSG) and security control list (SCL) rules. For a packet to reach a target, it must pass all NSG and SCL rules and ZPR policy. The request is dropped if any NSG, SCL, or ZPR rule or policy doesn't allow traffic. For Autonomous Database deployments on Oracle Public Cloud, you can apply ZPR security attributes to an AVMC while provisioning it or later. See the following pages for more information: |
Export data to Cloud Object Storage as Parquet. |
Use See Export Data to Object Store as Text Using DBMS_CLOUD.EXPORT_DATA for more information. |
Parent topic: New Feature Announcements
September 2024
Feature | Description |
---|---|
Availability of new Dynamic Performance Views on Autonomous Database on Dedicated Exadata Infrastructure. |
You can use Dynamic Performance Views to:
See Dynamic Performance Views for additional information. |
Parent topic: New Feature Announcements
August 2024
Feature | Description |
---|---|
Select AI with OCI Generative AI |
Autonomous Database can interact with AI service providers. Select AI now supports OCI Generative AI and Azure OpenAI Service. 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 to Generate SQL from Natural Language Prompts for more information. |
DBMS_PIPE Support |
The DBMS_PIPE package lets two or more sessions in the same instance communicate is available in Autonomous Database. 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. The DBMS_PIPE package also supports persistent messaging, where messages are stored in Cloud Object Store. See Cache Messages with Singleton Pipes, Use Persistent Messaging with Messages Stored in Cloud Object Store, DBMS_PIPE Package (Singleton Pipes), and DBMS_PIPE Package (Persistent Messaging Pipes) for more information. |
Ability to update an Autonomous Container Database using a Custom database software image. |
You can choose to update your Autonomous Container Database using an existing custom database software image with rolling or non-rolling maintenance methods. See Schedule a Quarterly Maintenance Update for additional information. |
Version-enable one or more user tables using 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. |
Parent topic: New Feature Announcements
July 2024
Feature | Description |
---|---|
Elastic Pools support |
On Oracle Public Cloud and Exadata Cloud@Customer deployments, you can 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. Refer to the following articles to know more about elastic pools, their terminology, billing, and related tutorials:
|
Ability to encrypt or decrypt data while exporting or importing data to or from Object Store. |
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. Encryption and decryption during import and export can be performed using DBMS_CRYPTO or using a user defined function. See Encrypt Data While Exporting to Object Storage and Decrypt Data While Importing from Object Storage for additional information. |
Cross tenancy cloning support on Oracle Public Cloud deployments. |
On Oracle Public Cloud deployments, you can clone an Autonomous Database instance or its backup from one tenancy (source tenancy) to a different tenancy (destination tenancy). The cloned database can be in the same region or in a different region (cross-region) and both full and metadata cloning support cross tenancy cloning. 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 the following articles for more information:
|
Doc update: Overview of an Autonomous Database |
Our documentation has been updated with a new article to provide a complete overview of Autonomous Database resources. This article answers all questions about Autonomous Databases, including what an Autonomous Database is, the requirements for creating an Autonomous Database, which database features can be defined or managed using the Autonomous Database resource, the tools available to Autonomous Database users, and provides related documentation to help you create and manage Autonomous Databases. |
Parent topic: New Feature Announcements
June 2024
Feature | Description |
---|---|
Customer-managed keys in Oracle Key Vault (OKV) for Oracle Public Cloud deployments of Autonomous Database on Dedicated Exadata Infrastructure. |
You can integrate your on-premises Oracle Key Vault (OKV) with Autonomous Database on Dedicated Exadata Infrastructure deployed on Oracle Public Cloud and use the customer-managed keys stored in Oracle Key Vault to secure your critical data. See Create Autonomous Container Database for details. Before you can use customer-managed keys stored in Oracle Key Vault, you must perform a number of preparatory configuration tasks as described in Prepare to Use Oracle Key Vault. |
Ability to create and manage Key Stores. |
You can create Key Stores using the Oracle Cloud Infrastructure (OCI) console to integrate your on-premises Oracle Key Vault deployment with Oracle Autonomous Database on Dedicated Exadata Infrastructure. These Key Stores let you create and manage your own the master keys using Oracle Key Vault. See Create and Manager Key Stores for instructions. |
Identity and Access Management (IAM) Integration with Autonomous Database on Exadata Cloud@Customer. |
You can configure an Autonomous Database on Exadata Cloud@Customer 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. As of this release, (IAM) authentication and authorization:
See Use Identity and Access Management (IAM) Authentication with Autonomous Database for more details. |
Azure Active Directory (Azure AD ) Integration with Autonomous Database on Exadata Cloud@Customer. |
Azure Active Directory (Azure AD ) users can now connect to an Autonomous Database deployed on Exadata Cloud@Customer using Azure OAuth2 access tokens. See Authenticate and Authorize Microsoft Azure Active Directory Users for Autonomous Database for more information. |
Parent topic: New Feature Announcements
May 2024
Feature | Description |
---|---|
23ai database support on Autonomous Database on Dedicated Exadata Infrastructure |
You can provision 23ai Autonomous Database on Dedicated Exadata Infrastructure on Oracle Public Cloud and Exadata Cloud@Customer deployments , allowing you to take advantage of all the new features that Oracle Database 23ai offers. 23ai database is currently supported with the following limitations:
|
Support for Database Links from Autonomous Database on Dedicated Exadata Infrastructure to another Autonomous Database |
You can create TLS and Non-TLS database links from Autonomous Database on Dedicated Exadata Infrastructure to a target Autonomous Database using the Refer to the following articles for more information:
|
Support for Database Links from Autonomous Database on Dedicated Exadata Infrastructure to Oracle Database. |
You can create database links from Autonomous Database on Dedicated Exadata Infrastructure to a target Oracle database that is either on a public endpoint or a private endpoint using the |
Doc update: Overview of an Autonomous Exadata VM Cluster (AVMC) |
Our documentation has been updated with a new article to provide a complete overview of Autonomous Exadata VM Cluster resources. This article answers all questions about Autonomous Exadata VM Clusters, including what an AVMC is, the requirements for creating an AVMC, which database features can be defined or managed using the AVMC resource, and provides related documentation to help you create and manage AVMCs. |
Network File System (NFS) NFSv4 Support |
You can attach external NFS devices provided by the customer on an NFSv4 server to Autonomous Database, using the Refer to the following for more information:
|
Amazon S3 Presigned URLs |
You can use a presigned URL in any See Amazon S3 Compatible URI Format for more information. |
Parent topic: New Feature Announcements
April 2024
Feature | Description |
---|---|
Doc update: Use case demonstration to configure Autonomous Database on Dedicated Exadata Infrastructure for proof of concept (POC) applications. |
Our documentation is updated with a use case demonstrating how to quickly configure your Autonomous Database resources on Dedicated Exadata Infrastructure for developing proof of concept (POC) applications. If you are looking to quickly create an Autonomous Database POC environment, see Use Case: Configure Autonomous Database for Proof of Concept (POC). |
Doc Update: Instructions to request a service limit increase. |
We have added a new article that demonstrates how to submit a request to increase your service limits using the Oracle Cloud Infrastructure console to add Exadata Infrastructure resources - Database Servers and Storage Servers to the tenancy. See Request a Service Limit Increase for details. |
View and manage customer contacts for operational issues and announcements. |
When customer contacts are set, Oracle sends announcements, operational notifications, and unplanned maintenance notifications to the specified email addresses. You can add email contacts while provisioning Autonomous Databases. You can also view and modify customer contacts for an existing Autonomous Database using the Oracle Cloud Infrastructure console. See Manage Customer Contacts for more information. |
Ability to provision an Autonomous Container Database using the Oracle Database software version of an Autonomous Database software image . |
You can choose the latest Oracle Database software version, its immediate predecessor, or a custom database software image as the Container Database software version while provisioning an Autonomous Container Database. See Create an Autonomous Container Database for instructions. |
Ability to create Autonomous Database software images. |
You can create Autonomous Database software images and use them as standard images for provisioning Autonomous Container Databases. See Create an Autonomous Database software image for instructions. |
Ability to view and copy a list of one-off patches available for an Autonomous Container Database. |
You can view and copy a list of one-off patches from the Autonomous Container Database Details page. See Service Maintenance of Autonomous Database on Dedicated Exadata Infrastructure for more details. |
Ability to skip maintenance updates for a quarter. |
You can customize your service maintenance preferences to skip patching a Release Update (RU) for one quarter. You cannot skip the maintenance updates for two consecutive quarters. See Update Autonomous Container Database Maintenance Preferences for more details. |
Use DBMS_CLOUD_PIPELINE to create data pipelines for loading and exporting data in the cloud.
|
You can use See DBMS_CLOUD_PIPELINE Package for more information. |
Use DBMS_CLOUD_REPO to use and manage cloud hosted code repositories from Oracle Database.
|
You can use Supported code repositories include GitHub, AWS CodeCommit, and Azure Repos. See About DBMS_CLOUD_REPO for more information. |
Doc update: Use case demonstration to configure Autonomous Database on Dedicated Exadata Infrastructure with reference architecture. |
Our documentation is updated with a use case demonstrating how to configure an Autonomous Database on Dedicated Exadata Infrastructure to leverage its capabilities better. See Use Case: Configure Autonomous Database with Reference Architecture for a comprehensive and recommended configuration that involves setting up separate development and production Autonomous Database environments. |
Connect to Autonomous Database on Dedicated Exadata Infrastructure without a wallet. |
You can connect your database applications or tools to an Autonomous Database on Dedicated Exadata Infrastructure without a wallet. Connecting an application without a wallet (TLS) provides security for authentication and encryption, and security is enforced using a security certificate that is trusted by the client operating system (OS). See Prepare for TLS Walletless Connections 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. Refer to the following articles for more information:
|
Create a text index on the Object Storage files. |
You can create a text index on the Object Storage files specified at the See CREATE_EXTERNAL_TEXT_INDEX and DROP_EXTERNAL_TEXT_INDEX for reference. |
Parent topic: New Feature Announcements
March 2024
Feature | Description |
---|---|
Doc update: Overview of an Autonomous Container Database (ACD) |
Our documentation has been updated with a new article to provide a complete overview of Autonomous Container Database resources. This article answers all questions about Autonomous Container Databases, including what an ACD is, the requirements for creating an ACD, which database features can be defined or managed using the ACD resource, and provides related documentation to help you create and manage ACDs. |
Free developer database instances |
Customers who have subscribed to Oracle Exadata Database Service or Autonomous Database on either Dedicated Exadata Infrastructure or Exadata Cloud@Customer can create and use Autonomous Database for Developers instances. Autonomous Database for Developers instances are free Autonomous Databases that developers can use to build and test new applications. With Autonomous Database for Developers instances, you can try new Autonomous Database features for free and apply them to ongoing or new development projects. Developer database comes with limited resources and is, therefore, not suitable for large-scale testing and production deployments. When you need more compute or storage resources, you can transition to a paid database licensing by cloning your developer database into a regular Autonomous Database. Refer to Autonomous Database for Developers for more details. |
Shared Server configuration for Autonomous Database applications |
Autonomous Database on Dedicated Exadata Infrastructure supports Shared Server Configuration for maintaining legacy applications designed without connection pooling. You can enable shared server configuration while provisioning an Autonomous Container Database. For more details, see the Shared Server Configuration section in Special-Purpose Connection Features. |
Autonomous Database resource management |
Autonomous Database on Dedicated Exadata Infrastructure lets you configure the following attributes to a value that is most appropriate for your database while provisioning an Autonomous Container Database (ACD):
This capability improves your resource management ability to either consolidate more databases or have the highest database availability. See Create an Autonomous Container Database for more details. |
Export data using DBMS_CLOUD.EXPORT_DATA |
You can use the |
Parent topic: New Feature Announcements
February 2024
Feature | Description |
---|---|
Enable Autonomous Data Guard and add a standby database on an Autonomous Container Database on Exadata Cloud@Customer deployments. |
On Exadata Cloud@Customer deployments, you can enable Autonomous Data Guard and add a standby Autonomous Container Database (ACD) to ACDs provisioned already. For more information, see Enable Autonomous Data Guard on an Autonomous Container Database. |
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 to Generate SQL from Natural Language Prompts for more information. To get a list of AI profiles and their attributes created in your Autonomous Database or schema, you can use the See DBMS_CLOUD_AI Views for more information. |
Send Microsoft Teams notifications from Autonomous Database on Dedicated Exadata Infrastructure on Exadata Cloud@Customer deployments. |
On Exadata Cloud@Customer deployments, you have the capability to 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 Slack notifications from Autonomous Database on Dedicated Exadata Infrastructure on Exadata Cloud@Customer deployments. |
On Exadata Cloud@Customer deployments, you have the capability to send Slack notifications from Autonomous Database. This feature enables you to send messages to a Slack channel or share the results of a query to a Slack channel. See Send Slack Notifications from Autonomous Database for more information. |
Rolling rotation of database SSL certificates. |
With the rolling rotation of database SSL certificates, your existing database SSL certificate is not invalidated immediately after rotating it. Within two weeks from the certificate rotation, you can connect to your databases using the Autonomous Database client wallet you downloaded before or after the certificate rotation. After two weeks from the certificate rotation:
Refer to Certificate Management for complete details. |
New events for Autonomous Container Databases. |
You can get notified when your Autonomous Container Database's backup destination uses 80% of the storage space, runs out of storage space, has incorrect permissions set, or returns to a healthy state. To subscribe to event notifications, see Use Events and Notifications to Watch Resource Activity. Refer to Events for Autonomous Database on Dedicated Exadata Infrastructure for a complete list of events emitted by the Autonomous Database resources. |
Parent topic: New Feature Announcements
January 2024
Feature | Description |
---|---|
Send email using DBMS_CLOUD_NOTIFICATION from Autonomous Databases deployed on Oracle Public Cloud.
|
On Oracle Public Cloud, you can use the See Send Email on Autonomous Database on Dedicated Exadata Infrastructure for more information. |
Send Microsoft Teams notifications from Autonomous Databases deployed on Oracle Public Cloud. |
On Oracle Public Cloud, you have the capability to send messages, alerts, or query results from an Autonomous Database to a Microsoft Teams Channel. See Send Microsoft Teams Notifications from Autonomous Database for more information. |
Send Slack notifications from Autonomous Databases deployed on Oracle Public Cloud. |
On Oracle Public Cloud deployments, you have the capability to send Slack notifications from an Autonomous Database. This feature enables you to send messages or share the results of a query to a Slack channel. See Send Slack Notifications from Autonomous Database for more information. |
Parent topic: New Feature Announcements