What’s New for Oracle Autonomous Database Serverless
Here’s a summary of the noteworthy Oracle Autonomous Database additions and enhancements.
You can also visit the What's New Videos for announcements and details on new Autonomous Database features.
See Previous Feature Announcements for 2022 announcements and older announcements.
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- January 2023
Parent topic: Overview
December 2023
Feature | Description |
---|---|
New Cloud Links Views |
Two views are added for tracking granted privileges
on Cloud Links: 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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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 to Generate SQL from Natural Language Prompts for more information. |
Break Glass Access with |
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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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:
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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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 to Generate SQL from Natural Language Prompts 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 Resource Pools |
Use an elastic resource pool to consolidate your Autonomous Database instances, in terms of their allocation of compute resources, and to provide up to 8 times cost savings. See Use and Manage Elastic Resource Pools on Autonomous Database for more information. |
Autonomous Database Free Container Image |
Use the Oracle 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 Oracle 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 Autonomous Database 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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
August 2023
Feature | Description |
---|---|
|
You can use the subprograms and views in the
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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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 |
See DBMS_CLOUD Endpoint Management for more information. |
|
The 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 |
Export files as text or as Oracle Data Pump dump files to a directory. See Export Data to a Directory for more information. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
June 2023
Feature | Description |
---|---|
Oracle Cloud Infrastructure Signing Key Based Authentication for Oracle Data Pump Import |
Oracle Data Pump import using 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
See About Critical Events on Autonomous Database for more information. |
Operator Access Event |
The 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:
See Use Microsoft Active Directory with Autonomous Database for more information. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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 |
See DBMS_CLOUD Package Format Options for more information. |
|
Set the 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 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 |
The 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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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
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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
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 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 |
As an alternative to an object store location URI,
you can specify a directory with See Load Data from Directories in Autonomous Database for more information. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
February 2023
Feature | Description |
---|---|
Maximum Storage Space Metric |
The 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 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 The See About Critical Events on Autonomous Database for more information. |
Parent topic: What’s New for Oracle Autonomous Database Serverless
January 2023
Feature | Description |
---|---|
ECPU Compute Model |
Autonomous Database offers two compute models when you create or clone an instance: ECPU and OCPU. The ECPU compute model is not enabled by default. If you want to create an Autonomous Database instance that uses ECPUs, file a Service Request at Oracle Cloud Support. 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. |
Parent topic: What’s New for Oracle Autonomous Database Serverless