Previous Feature Announcements

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

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

2025 What's New

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

December 2025

Feature Description

MCP Server for Autonomous AI Database

Autonomous AI Database now includes a built-in MCP Server that provides a managed, per-database MCP server for Oracle Autonomous AI Database on Serverless Exadata Infrastructure (26ai and 19c). With MCP Server, AI agents supporting MCP can securely access and call Autonomous AI Database Select AI Agent tools without the need for any additional infrastructure for MCP Server deployment.

See Autonomous AI Database MCP Server for more information.

Optimize costs with dedicated elastic pools in Autonomous AI Database

You can create dedicated elastic pools in Autonomous AI Database, where the pool leader and all members reside on the same infrastructure. This configuration enables you to control Database, ORDS, and APEX patching, and provides simplified storage billing. These benefits make dedicated elastic pools suitable for SaaS applications, microservices, or workloads with huge number of relatively smaller databases.

Support for transportable tablespaces

You can use the Transportable Tablespace feature in Autonomous AI Database to efficiently migrate data and metadata from on premise Oracle databases or Oracle Database Cloud Service (DBCS) databases to Autonomous AI Database. This capability simplifies your migration process, enabling you to move large volumes of data with minimal downtime and operational effort.

See Migrate Data Using Transportable Tablespaces for more information.

Wallet rotation with a grace period

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

See Rotate Wallets for Autonomous AI Database for more information.

Autonomous AI Database API for DynamoDB

You can use the Autonomous AI Database API for DynamoDB to work seamlessly with Autonomous AI Database using your existing DynamoDB tools and SDKs. Leverage standard DynamoDB SDKs and operations such as GetItem, DeleteItem, CreateTable, and DeleteTable with minimal changes to run, migrate, and modify your applications on an Autonomous AI Database.

See Use Autonomous AI Database API for DynamoDB for more information.

Provider Scoped Table Hyperlink

Providers define scopes (tenancy, compartment, schema, or object level) to authorize specific consumers to generate Table Hyperlinks without manual sharing.

See DBMS_DATA_ACCESS_SCOPE Package, DBMS_DATA_ACCESS_ADMIN Package and DBMS_DATA_ACCESS Package for more information.

Consumers with granted read privileges then create federated external tables via the DBMS_DATA_ACCESS.CREATE_FEDERATED_TABLE procedure. This enables secure data aggregation across Autonomous AI Database instances. This capability simplifies sharing and enhances security by avoiding Table Hyperlink (URL) distribution.

Use Customer-managed keys in cross tenancy clones and cross tenancy Autonomous Data Guard

When a source database uses customer-managed encryption keys, you have several options for specifying the encryption key type and location for a cross tenancy clone. See Cross Tenancy Cloning Encryption Key Options.

When you add an Autonomous Data Guard cross tenancy standby, if the Primary database uses a customer-managed encryption key, you can use the same key in the standby. See Cross Tenancy Autonomous Data Guard with Customer-Managed Encryption Keys.

Currently, this feature is available in all OC1 regions excluding:

  • US East: Ashburn (IAD)
  • US Midwest: Chicago (ORD)
  • US West: Phoenix (PHX)
  • Australia East: Sydney (SYD)
  • Australia Southeast: Melbourne (MEL)
  • Japan East: Tokyo (NRT)
  • Japan Central: Osaka (KIX)
  • Brazil East: Sao Paulo (GRU)
  • Brazil Southeast: Vinhedo (VCP)
  • Saudi Arabia West: Jeddah (JED)
  • Saudi Arabia Central: Riyadh (RUH)
  • UK South: London (LHR)
  • Germany Central: Frankfurt (FRA)
Manage workload resources using Database Resource Manager

You can use cs_resource_manager subprograms in an Autonomous AI Database to define and manage your own Database Resource Manager plans. This feature enables you to create custom consumer groups, set resource usage policies, control workload prioritization, and specify detailed resource allocation rules for specific workloads.

Refer to:

Data Transforms Enhancements

Data Transforms includes the following new features and changes:
  • View dependencies and delete objects

    You can now check where an object is used before deleting it. You can view dependencies and delete one or more of the following object types:
    • Connections - All data entities associated with the connection are deleted. Any data loads that use this connection as source or target are also removed. See View and Manage Connections.
    • Schemas - All data entities associated with the schema are removed. See View and Manage Connections.
    • Data Loads - The data load and any workflow steps that reference this data load are deleted. See View and Manage Data Loads.
    • Data Entities - Any data flows that reference the deleted data entities become invalid. Data load jobs for loading deleted data entities will fail. No additional objects are deleted. See View and Manage Data Entities.
    • Data Flows - The data flow and any workflow steps that reference this data flow are deleted. See View and Manage Data Flows.
    • Workflows - The workflow and any workflow steps that reference this workflow are deleted. See View and Manage Workflows.
  • Enhancements to Oracle Financials Cloud connector

    You can now choose from two options to create an Oracle Financials Cloud connection. The Application tab on the Create Connection page includes the options - Oracle Financials Cloud and Oracle Financials Cloud Rest. See Create an Oracle Financials Cloud Connection.

  • Cross platform support for Design Migration

    Data Transforms now supports cross platform import of objects from a Data Transforms Marketplace instance to a Data Transforms Autonomous Database instance. Note that, currently, you cannot import objects between any of the other supported platforms. See Export and Import Objects for information about exporting and importing objects within environments.

November 2025

Feature Description

Chart Support in Table Hyperlinks

With Chart View in Table Hyperlinks, you can switch between tabular and chart views for better analysis experience. The Chart View supports multiple data visualization types, including Bar, line, Scatter and Pie charts for detailed comparisons. You can also customize chart settings that enhances the ability to visualize and interpret data accurately.

See Access Data in Chart Format with Table Hyperlinks.

You can also switch views, show or hide columns, and split or combine table groups using the Table Hyperlink Hamburger menu options for customized data presentation.

See Manage Data with the Table Hyperlink Hamburger Menu.

OML notebook and GitHub integration

Oracle Machine Learning UI has been enhanced to support direct interaction of OML Notebooks with your external GitHub repositories. You can now directly import notebooks from your GitHub repositories. With GitHub integration, you can interact with your GitHub repositories in the following ways:

  • Notebook clone and import: You can import notebooks directly from your GitHub repository. When you import notebooks from your GitHub repository, it clones the notebooks and creates a local copy in OML UI by using the branching mechanism in GitHub. See Clone and Access your GitHub Notebook for more information.

  • Notebook updates: You can update remote changes in your notebooks and also upload local changes in the notebooks back to your GitHub repository using the version control options Pull changes and Push & commit in OML notebook editor. See Edit and Sync your GitHub notebook for more information.

  • Credential management: You must have separate credentials to connect to your GitHub repositories. The credentials are created and securely stored in the Autonomous AI Database. See Create GitHub Credentials for more information.

Data Studio Enhancements: DBMS_CATALOG REST API Functions for the Catalog Tool

The Catalog tool of the Data Studio Suite of tools provides PL/SQL APIs to manage catalogs using the DBMS_CATALOG package.

See Manage Catalogs with DBMS_CATALOG.

Autonomous Data Guard Support for JSON and APEX workloads

You can enable Autonomous Data Guard on Autonomous AI Databases with the JSON and APEX workloads for both local and cross-region standby databases.

For more details, see Enable Autonomous Data Guard.

Data Transforms Enhancements

Data Transforms includes the following new features and changes:
  • Use SQL Queries to Generate Data Flow

    You can use SQL statements to build a data flow. The Data Transforms SQL Parser analyzes the SQL statement, generates the data flow, and displays it on the Design Canvas. See Generate Data Flow from SQL Statements.

  • Materialized Views in Data Flows

    Data Transforms supports the use of materialized views in a data flow. You can create a materialized view data entity, define the refresh settings of the view, and use it as a source in a data flow. See Create and Use a Materialized View in a Data Flow.

  • Data Load support for Oracle Business Intelligence Cloud Connector

    You can use an Oracle Business Intelligence Cloud Connector (BICC) connection to load data to Oracle Autonomous Database. For BICC data loads, you have two options - Incremental Merge, which updates the data in the selected column by comparing the source table with the target table and Incremental w/Deletes that deletes records from the target table that are no longer available in the source table. See Create an Oracle Business Intelligence Cloud Connector Connection.

  • Data Load Job Details Enhancements

    The Job Details page for data load jobs includes the Rerun Selected Tables option that allows you to rerun the job for selected tables. This is useful when you want to reload only a few tables instead of rerunning the entire data load job. See Create and Manage Jobs.

  • REST API for Oracle Data Transforms

    External systems and developers can use Data Transforms REST APIs to retrieve information about Data Transforms such as projects, connections, data loads, data flows, workflows, schedules, and variables. You can also use REST APIs for secure authentication as well as to export and import design objects. See REST API for Oracle Data Transforms.

Data Lake Accelerator

You can use Data Lake Accelerator with Autonomous AI Database 26ai instances to support external data processing. It runs on an Oracle-managed VM cluster and connects to your Autonomous AI Database to scan and process external data stored in Object Stores. The service automatically adds CPUs as query demand increases, helping you manage resource usage and improve query response times when you work with large datasets.

See Data Lake Accelerator for more information.

October 2025

Feature Description

Vanity URL support using API Gateway

For a database in an elastic pool, you can enable a vanity URL on your Autonomous AI Database and configure a vanity URL custom domain for your Autonomous AI Database instance using an API Gateway.

See Enable a Vanity URL on your Elastic Pool Member Database.

Live workload capture-replay between Autonomous AI Databases

You can use live workload capture-replay to capture workloads running on a source Autonomous AI Database instance and simultaneously replay them on a target refreshable clone, as the workload runs on the source database.

See Test Workloads with Oracle Real Application Testing for more information.

Invoke Python scripts with the WITH_CONTEXT attribute from an Autonomous AI Database instance

You can invoke Python scripts with the WITH_CONTEXT attribute from an Autonomous AI Database instance. To run a Python script, the script is hosted remotely on an Oracle provided Autonomous AI Database container image with the EXTPROC agent installed.

See Invoke Python Scripts with WITH_CONTEXT on Autonomous AI Database for more information.

Automatic caching for external tables

External Table Cache in Autonomous AI Database enables you to cache frequently accessed data from external tables in your database. You can choose either policy-based or automatic caching for your external tables. With policy-based management, you define how caches are created, populated, refreshed, and retired, giving you precise control over cache contents and lifecycle. With automatic caching, the database manages the entire cache lifecycle, including creation, population, refresh, and drop of external table caches.

See Use External Table Cache to Improve Performance for External Tables for more information.

Oracle Autonomous AI Database

Oracle AI Database architects Artificial Intelligence (AI) into its core, seamlessly integrating AI across all major data types and workloads. See the Press Release for details.

As a result, Oracle Autonomous Database becomes Oracle Autonomous AI Database. Additionally, Oracle Autonomous Transaction Processing is Oracle Autonomous AI Transaction Processing, and Oracle Autonomous JSON Database is Oracle Autonomous AI JSON Database.

Oracle Autonomous AI Lakehouse has been added as the next generation of Autonomous Data Warehouse. It retains all functionality while introducing a host of capabilities for tightly integrating with Iceberg and other open-source technologies. See the Press Release for details. Refer to About Oracle Autonomous AI Lakehouse for an overview.

Oracle Autonomous AI Database 26ai replaces Oracle Autonomous Database 23ai. As a result, you can continue to use CreateAutonomousDatabase with 23ai for dbVersion. The REST API returns 23ai, but you will see 26ai in the Oracle Cloud Infrastructure (OCI) console.

You can notice the new service names in the Oracle Cloud Infrastructure (OCI) console, REST API, and related documentation. See Oracle Autonomous AI Database for more details.

Billing changes for Elastic Pools with Autonomous Data Guard enabled with a local standby

Autonomous Data Guard can be enabled for elastic pools with local standbys. When the aggregated peak of the local Autonomous Data Guard standby databases in your elastic pool causes the hourly peak of the elastic pool to fall within the next billing tier, the aggregated peak of pool members and the aggregated peak for local Autonomous Data Guard standbys are calculated separately to provide you a cost advantage.

See About Elastic Pool Billing with Autonomous Data Guard Enabled with a Local Standby for more information.

Backup and restore with Autonomous AI Database for Developers

Autonomous AI Database for Developers supports the backup and restore features available on Autonomous AI Database.

See Backup and Restore Autonomous AI Database Instances for more information.

Broader and enhanced Iceberg REST catalog support

You can integrate with a broader Iceberg REST catalog ecosystem with the support of Databricks Unity and Snowflake Polaris, in addition to the existing integration with Amazon Glue and location-based Iceberg root metadata files.

See Query Apache Iceberg Tables for more information.

Select AI Agent (autonomous agent framework)

Select AI Agent (autonomous agent framework) introduces a framework for building agentic workflows enabling developers to create agents, tools, tasks, and teams that reason, act, and collaborate using generative AI within the database.

Agents can plan actions, use built-in or custom tools (such as SQL, RAG, Websearch, or Notification), and maintain context across multi-turn conversations. This feature enables developers to create agentic workflows using SQL and PL/SQL that support AI-driven automation, data interaction, and human-in-the-loop control.

See Select AI Agent, DBMS_CLOUD_AI_AGENT Package, DBMS_CLOUD_AI_AGENT Views, and Examples of Using Select AI Agent to explore this feature.

Select AI Translate

The Translate feature enables you to translate your text across multiple languages using SQL or PL/SQL, as supported by your AI provider. .

See Translate, Example: Select AI Translate, TRANSLATE Function, and GENERATE Function to explore this feature

TP and TPURGENT predefined database service names for Autonomous AI Lakehouse workload.

You can run a mixed workload for data analytics and critical transaction processing by connecting to Autonomous AI Lakehouse databases using the TP and TPURGENT predefined database services. This lets you run critical transaction processing workloads with or without parallelism while connected to an Autonomous AI Lakehouse database.

For more details, see Predefined Database Service Names for Autonomous AI Database and Database Service Names for Autonomous AI Database.

September 2025

Feature Description

Run Workload Capture/Replay from Database Actions

You can test your workloads in Database Actions by capturing a workload on production system and replay it on test system.

See Use Database Actions to Capture and Replay Workloads for more information.

Select AI for Python

You can now use Select AI for Python to access DBMS_CLOUD_AI capabilities in Autonomous AI Database from Python applications. With Select AI for Python, you can:
  • Ask questions about your database data using natural language (NL2SQL)

  • View and explain AI-generated SQL queries

  • Chat with your LLM with customized prompts

  • Use automated processes for creating vector indexes and using Retrieval-Augmented Generation (RAG)

  • Generate synthetic data using large language models to populate database tables

  • Conduct conversational AI sessions for short-term and long-term memory

See Select AI for Python for more information.

Select AI Conversations

Select AI supports customizable conversations enabling you to use Select AI with different topics without mixing context, improving both flexibility and efficiency. You can create, set, delete, and update conversations through the DBMS_CLOUD_AI conversation procedures and functions.

See Select AI Conversations, Example: Enable Conversations in Select AI, and Summary of DBMS_CLOUD_AI Subprograms for more information.

Select AI Feedback

Select AI enables you to give feedback on generated NL2SQL results to improve query generation accuracy. Feedback can be given on the SQL command line as well as through PL/SQL procedures.

See Feedback, Example: Select AI Feedback, and FEEDBACK Procedure to explore the feature.

Select AI Summarize

Select AI enables you to generate a summary of your text directly in a prompt or from a URI. You can customize how the summary is generated.

See Generate a Summary with Select AI to explore the feature.

Use DBMS_CLOUD.CREATE_EXTERNAL_TABLE with Implicit Partitioning with the Format Option Strict Column Order

Use the DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure to create implicit partitioned external tables. By passing the appropriate options to this procedure, the partitions are derived from the source data. The partitioned external tables support runtime discovery of partition columns and their values. Runtime discovery of changes in the underlying object store structure, such as adding or removing objects, simplifies the maintenance process by eliminating the need for additional synchronization procedures required by DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE. This ensures that the data is up to date at query runtime.

See Query External Tables with Implicit Partitioning for more information.

Access Table Hyperlinks with Explicit ACLs

You can generate a Table Hyperlink with ACL checking enabled. You can use either individual Table Hyperlink ACL checking or instance level ACL checking, or both for your Table Hyperlinks.

Directory File Support for Data Pipelines and AI

You can use directory files, including those in network file systems, with data pipelines and the SELECT AI vector index in Autonomous AI Database. All functions available with object storage files and vector index are supported with directory files.

Wild Card File Selection in Autonomous Database APIs

You can use wild card patterns to select multiple files in both object storage and directory objects when working with DBMS_CLOUD, DBMS_CLOUD_PIPELINE, and DBMS_CLOUD_AI in Autonomous AI Database.

Use Table Hyperlinks to Access Data using Spreadsheet Add-ins

You can read and access data with a Table Hyperlink in a Google Sheet using Oracle Autonomous Database Add-on for Google Sheets.

See Use Table Hyperlinks to Access Data in Google Sheets and Read and Access Data Using Table Hyperlinks in Google Sheets for more information.

Create Password-Protected Table Hyperlinks

You can create a password-protected Table Hyperlink by specifying a Table Hyperlink password. This provides an additional security step to avoid malicious access in the case where a Table Hyperlink is exposed to a wider audience than intended.

See Use Table Hyperlinks for Read Only Data Access on Autonomous AI Database for more information.

Refreshable Metadata Clones

Autonomous AI Database provides cloning where you can choose to create a full clone of the active instance, create a metadata clone, create a refreshable clone, or create a refreshable metadata clone. With a refreshable metadata clone the system creates a clone that only includes the metadata from the source database and can be easily updated with changes from the source database.

See Create a Refreshable Clone for an Autonomous AI Database Instance for more information.

Use Cloud Tables to Store Logging and Diagnostic Information

You can create Cloud Tables where table data resides on Oracle managed Cloud Storage and the table data does not consume database storage. These tables are useful for storing infrequently accessed data such as application logs, or diagnostic information.

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

Enable Consistent View of Data across Table Hyperlinks

When you create a Table Hyperlink or a Table Hyperlink Group, you can set the consistent parameter to specify that the producer provides data consistently across different pages when a consumer access data.

See Use Table Hyperlinks for Read Only Data Access on Autonomous AI Database for more information.

Dataplane Events:

UnplannedMaintenanceBegin and UnplannedMaintenanceEnd

The UnplannedMaintenanceBegin event is triggered when the maintenance required for urgent and unplanned situations is initiated.

The UnplannedMaintenanceEnd event is triggered when the maintenance required for urgent and unplanned situations is completed successfully.

See Information Events on Autonomous AI Database for more information.

View Space Usage Information for Non-JSON Objects

Query the DBA_NONJSON_OBJECTS view to assess the space consumed by non-JSON objects on an Autonomous AI Database instance. This view is only accessible to the ADMIN user.

See Update Autonomous AI JSON Database to Autonomous AI Transaction Processing and DBA_NONJSON_OBJECTS View for more information.

Provide Available Elastic Pool Capacity

When you join an existing elastic pool or list an elastic pool, you can view the available elastic pool capacity.

See Join an Existing Elastic Pool and List Elastic Pool Members for more information.

Data Transforms Enhancements

Data Transforms includes the following new features and changes:
  • Autojoin Associated Tables in a Dataflow

    You can now use the SQL auto-join feature in the the Data Flow editor to establish joins between tables based on a predefined relationships such as foreign key constraints or common column names. See Use Auto-join to Map Associated Tables in a Data Flow.

  • Export and import artifacts at the Folder level

    You can now include folders when moving Data Transforms artifacts from one environment and import them into another. For instructions about exporting and importing objects, see Export and Import Objects.

  • Support for the Google Analytics 4

    This release includes support for the Google Analytics 4 application connection type. For the complete list of supported connection types, see Supported Connection Types.

August 2025

Feature Description

Upgrade to Oracle AI Database 26ai with Scheduled Upgrade

If your Autonomous AI Database instance is using Oracle Database 19c, you can upgrade to Oracle AI Database 26ai with Scheduled Upgrade.

See Upgrade to Oracle AI Database 26ai with Scheduled Upgrade for more information.

External Table Cache

External Table Cache in Autonomous AI Database enables you to cache frequently accessed data from external tables in your database. This can provide improved performance where queries run much faster for frequently accessed external data.

See Use External Table Cache to Improve Performance for External Tables for more information.

View or Copy Connection Code Samples

You can view or copy connection code samples for different connectivity options for Autonomous AI Database.

See Code Examples for Connecting to Autonomous AI Database Instance for more information.

URL Substitution Variables in Oracle Cloud Infrastructure URIs

Substitution variables are pre-defined placeholders which are resolved and substituted with the corresponding actual values based on the runtime context of your Autonomous AI Database. This allows you to include environment-specific values in Oracle Cloud Infrastructure URLs such as a tenancy OCID or a namespace, that are not hard coded, making your SQL code dynamic and portable to multiple regions.

See Substitution Variables in Oracle Cloud Infrastructure (OCI) URLs for more information.

July 2025

Feature Description

Unified Query Offload with Cloud Links

When you have heavy read workloads using cloud links you can configure an elastic pool leader or member as a cloud links provider, where the provider enables ProxySQL query offload to offload queries (reads) to any number of refreshable clones.

See Use Unified Query Offload with Cloud Links for more information.

Invoke Generic Scripts from an Autonomous AI Database Instance

You can invoke generic scripts, of type BASH, C, or Python from an Autonomous AI Database instance. To run a generic script, the script is hosted remotely on an Oracle provided Autonomous AI Database container image with the EXTPROC agent installed.

See Invoke Generic Scripts on an Autonomous Database Instance for more information.

Resource Utilization Warning Event

The ResourceUtilizationWarning event is generated as a warning for compute usage, storage usage, and number of sessions when certain thresholds are exceeded.

This event is only generated for an Autonomous AI Database with the ECPU compute model.

See Information Events on Autonomous AI Database for more information.

Select AI Extends Support to AI Providers

Select AI extends its support to the following AI providers:
  • AWS
  • OpenAI-Compatible

See Select your AI Provider and LLMs, Configure Select AI to Use Supported AI Providers, Example: Select AI with AWS, and Example: Select AI with OpenAI-Compatible Providers for more details.

Query for Client Errors

The view V$DIAG_ALERT_EXT is not available for alert log data. As a replacement use V$CLIENT_ERRORS to search for alert log related error data.

See Query for Client Errors for more information.

Enable Efficient Statement Routing with ProxySQL on Autonomous AI Database Instances in an Elastic Pool

ProxySQL enables unified access to multiple Autonomous AI Databases by routing statements for DML and queries, and eliminates the need to physically consolidate all the data into a single database.

See Use Efficient Statement Routing by Enabling ProxySQL on Autonomous AI Database for more information.

Use Table Hyperlink Groups

Table Hyperlink Groups allow you to access data from multiple objects or multiple SELECT statements through a single URL. Using a Table Hyperlink Group simplifies data retrieval by consolidating information from various objects into one access point (URL).

See Create and Manage Table Hyperlink Groups for more information.

Customer-Managed Keys Support for Refreshable Clones

Autonomous AI Database supports using customer-managed encryption keys with refreshable clones.

See Notes for Customer-Managed Encryption Keys with Refreshable Clones for more information.

Oracle Cloud Infrastructure Redwood UI

Oracle Cloud Infrastructure (OCI) has introduced new designs in the Oracle Cloud Console to enhance usability and consistency across services and experiences.

See Get to Know the Console for more information.

Documentation Addition: Best Practices for Application Availability During Maintenance

Autonomous AI Database patches are applied during a scheduled maintenance window as rolling patches. Using rolling patches, your Autonomous AI Database instance is made available on new cluster nodes before patching starts on the original nodes where it was running. After the database is available on new cluster nodes, all new connections are directed to the new nodes. This means the database remains online and available during maintenance and new database connection requests will succeed during the maintenance window.

See Best Practices to Maintain Application Availability During Maintenance Windows for more information.

Data Studio Enhancements:

The Data Studio is updated with new features and changes:
  • Data Studio Jobs feature:

    The Jobs feature in the Data Studio suite enables you to run tasks by automating them. You can run processes on a fixed schedule or trigger them based on specific events.

    With the Jobs feature, you can automate a variety of essential tasks including:
    • Data Loading: Import and update datasets using the Data Load Tool.

    • Data Augmentation: Enhance your data with AI-powered insights using the Table AI Assist Tool.

    • Database Operations: Run PL/SQL procedures to maintain your data in the backend.

    • API Integrations: Run REST calls to connect with external systems and integrate diverse data sources.

    See The Jobs Feature for more information.

  • Data Load BICC Support: The Data Load tool of the Data Studio suite of tool supports Business Intelligence Cloud Connector (BICC) data. You can export your BICC content to object storage and effortlessly load and integrate this data with the Autonomous Database.

    See Loading Data from Cloud Storage for more information.

  • Data Load Bulk Edit Wizard:
    You can update multiple columns at once using the Bulk Edit settings in the mapping table. Quickly search for specific columns and apply changes to all selected results in the pane. With Bulk Edit, you can:
    • Update values across entire groups of fields

    • Perform find and replace operations

    • Add prefixes or suffixes to target column names

    • Easily include or exclude columns for data loading into your target table

    See Bulk Edit Settings for more information.

  • Table AI Assistant Enhancements:

    You can interact with your data using the Table AI Assist tool with conversational AI technology. You can engage in natural language dialogues to query and analyze your database effortlessly. The tool understands context, adapts to your questions, and delivers precise, relevant responses.

    See Conversational AI for the Table AI Assist Tool for more information.

Data Lake Accelerator

You can use Data Lake Accelerator with Autonomous Database 19c instances to support external data processing. It runs on an Oracle-managed VM cluster and connects to your Autonomous Database to scan and process external data stored in Object Stores. The service automatically adds CPUs as query demand increases, helping you manage resource usage and improve query response times when you work with large datasets.

See Data Lake Accelerator for more information.

June 2025

Feature Description

Elastic Pool Support for Child Tenancies

You can combine Organization Management with the benefits of elastic pools. If your organization uses the parent/child tenancy model you can apply elastic pool cost savings by using an elastic pool that spans parent and child tenancies. In this way an elastic pool can operate across tenancies, where the elastic pool leader is in the parent tenancy and the elastic pool member is in a child tenancy.

See "Use Elastic Pools with Oracle Cloud Infrastructure Organization Management (Parent and Child Tenancies)" in About Elastic Pools for more information.

Table Hyperlink Network Access Checking with ACLs

You can generate a Table Hyperlink with ACL checking enabled. When you generate a Table Hyperlink and you enable ACL checking, Table Hyperlink data is only accessible to a consumer database after the incoming request's IP address is validated based on the ACLs defined on the producer database.

See Create, Manage, and Monitor Table Hyperlinks for more information.

Send Notifications to an OCI Notifications Service Topic

You can send messages from Autonomous AI Database to an OCI Notifications service topic.

See Send Messages to OCI Notifications Service from Autonomous AI Database for more information.

Critical and Information Events with Event Category

Critical events and Information events include an event category attribute. Optionally you can subscribe to events and add an event category to receive notifications about events in a category, or to perform other types of automation for events by event type and event category. The event categories are: Incident, Maintenance, Performance, Security, and Other.

See Use Autonomous AI Database Events for more information.

Data Studio Enhancements:

The Data Studio is updated with new features and changes:
  • Use SQL Syntax to Query Remote Catalogs:

    You can access external data by mounting catalogs and querying them using a simplified SQL syntax. This capability enables you to discover and analyze external data effortlessly.

    See Query Remote Catalogs and Databases for more information.

  • Use Table Hyperlinks to Access Data using Spreadsheet Add-ins:

    You can read and access data with a Table Hyperlink in a MS Excel Sheet using Oracle Autonomous Database Add-in for Excel.

    See Read and Access Data Using Table Hyperlinks in Excel Sheet for more information.

Select AI Enhancements

Select AI includes the following new features:

  • Select AI enables you to add table comments to the metadata of the LLM for a better SQL generation. You can achieve this by specifying comments to true in your AI profile. See "Example: Improve SQL Generation with Table and Column Comments" in Example: Improve SQL Query Generation.

  • Select AI integrates annotations in Oracle AI Database 26ai by adding it to the metadata that is sent to the LLM. You can achieve this by specifying annotations to true in your AI profile. See "Example: Improve SQL Query Generation with Table and Column Annotations" in Example: Improve SQL Query Generation

  • Select AI adds foreign key and referential key constraints into the metadata of the LLM to generate accurate JOIN conditions. You can achieve this by specifying constraints to true in your AI profile. See "Example: Improve SQL Query Generation with Foreign Key and Referential Key Constraints" in Example: Improve SQL Query Generation.

Cross-region Standby can be an Elastic Pool Member or an Elastic Pool Leader

A cross-region standby can be added to an elastic pool or can be an elastic pool leader. Elastic pools do not operate across regions; when a cross-region standby is added to an elastic pool, the primary and the standby cannot be in the same elastic pool.

See Optimize Costs with Elastic Pools on Autonomous AI Database for more information.

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

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

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

Built-in Tools Billing and Default Configuration Changes

In the ECPU compute model, the built-in database tools that use a VM, including: OML, Graph Studio, and Data Transforms have default configuration changes and billing changes.

See About Configuring Built-in Tools Compute Resources and Limits and Autonomous AI Database Serverless Billing for Database Tools for more information.

Elastic Pool Cost and Usage Information in Cost Reports

Elastic pool cost and usage details are recorded in the Oracle Cloud Infrastructure cost reports and in the OCI_COST_DATA view. See Autonomous AI Database Elastic Pool Billing and Compute Models in Autonomous AI Database for more information.

Offload Queries from Elastic Pool Member to Member Refreshable Clones: Includes Queries from PL/SQL and from Oracle Scheduler Jobs

When you have heavy read workloads, where a relatively small amount of data is scanned by multiple queries, including from PL/SQL or from Oracle Scheduler Jobs, you can offload queries (reads) from either an elastic pool leader or from an elastic pool member to Refreshable Clones.

See Offload Queries to Member Refreshable Clones for more information.

Data Transforms Enhancements Data Transforms is updated with new features and changes in the following areas:
  • Extract data from Oracle Enterprise Resource Planning (ERP) Cloud using BI Publisher

    You can now use the Oracle ERP Cloud connector to create a connection to the Business Intelligence (BI) Publisher server and load data from BI Publisher reports to Autonomous Database. You can use this as an alternate method to extract ERP data when BICC based extract is not sufficient. See Create an Oracle Analytics Publisher Connection.

  • Load Data to Apache Iceberg tables

    Data Transforms includes support for Apache Iceberg as a target to load data from SQL-based data sources. See Create an Apache Iceberg Connection.

  • Settings button on the Data Load Detail page

    The options under Advanced Options have moved into a separate window. Click the Settings button to use these options in addition to a few more.

.

May 2025

Feature Description

Remove OCPU Compute Model Option for Data Warehouse and Transaction Processing Workloads During Provisioning or Cloning

The OCPU compute model option is removed when you provision or clone a new Autonomous AI Database instance with Data Warehouse or Transaction Processing workloads.

See Oracle Support Document 2998742.1 for more information.

Support Zstd Compression in DBMS_CLOUD

DBMS_CLOUD supports loading and querying data using external tables as well as exporting and importing of data from Autonomous AI Database to object storage. DBMS_CLOUD supports Zstd (Zstandard) format for compression or decompression.

See DBMS_CLOUD Package Format Options and DBMS_CLOUD Package Format Options for EXPORT_DATA for more information.

Specify Default Bind Variables in Table Hyperlinks

You can specify default values for one or more bind variables in a SQL statement when the default_bind_values parameter is included with DBMS_DATA_ACCESS.GET_PREAUTHENTICATED_URL.

See Create a Table Hyperlink with a Select Statement and Use Table Hyperlink to Access Data for more information.

Select AI Enhancements

Select AI includes the following new features:

Use In-database Transformer Model with Select AI RAG

You can use in-database transformers (also known as embedding models) that you imported into your Oracle AI Database 26ai instance with Select AI RAG to generate vector embeddings for document chunks and user prompts. See Use In-database Transformer Models and Example: Select AI with In-database Transformer Models to explore this feature.

Data Transforms Updates

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

  • Run Data Studio Data Load using Data Transforms workflows

    You can now define a Data Studio Data Load in a Data Transforms workflow and then execute that data load as part of a Data Flow. You can then schedule the workflow to replay the Data Studio Data Load to capture any updates made to the files and load it into Autonomous Database.

    See Define a Data Studio Data Load in a Work Flow for more information about how you can run a Data Studio Data Load in Data Transforms.

  • Vector Embeddings in Data Flows

    Data Transforms now supports the integration of vector embeddings in a data flow using the Oracle Cloud Infrastructure (OCI) Generative AI service. Note that you need to have an Oracle Database 23ai connection to use this feature.

    For more information, see Use Text Embedding Vector in a Data Flow.

  • Use Machine Learning (ML) models in Data Flows

    Data Transforms now includes a new data entity type called ML Model. You can use ML Models in a data flow to apply prediction logic on source data and store the output in a target server.

    See Machine Learning (ML) Models for more information.

  • Set Custom Variable Value at Runtime

    For data flows and workflows that include variables as part of the flow, when you run the data flow or workflow you can choose to use the default value, the refresh value, or set a custom value at runtime to use for the current run.

    See Use Variables in a Data Flow and Use Variables in a Workflow for more information.

  • Show Queued/Waiting Jobs

    The Show Queued/Waiting Jobs option helps improve the overall performance when fetching the list of records to display on the Jobs page.

    See the Search for a Job section in Create and Manage Jobs for more information.

April 2025

Feature Description

Data Studio Enhancements

The Data Studio is updated with new features and changes:

  • The Autonomous Database Federated Database Catalog Enhancements:

    You can connect multiple catalogs to make it easier to find and work with your data, including popular Iceberg Data Catalogs like Unity and Polaris. You can also link to remote Autonomous Database instances using Database Links, allowing you to query tables from those databases directly within your catalog — helping you get more from your data catalog without extra steps.

    One of the major improvements in the Federated Catalog is the ability to easily load a Delta Share directly from the Catalog tool itself — no need to switch to a separate data loading tool.

    See Inline Data Load of Delta Share from the Catalog Tool for more details.

  • The Oracle Autonomous Database for Excel Add-in can now be installed from the Microsoft Store.

    See Install the add-in from Microsoft AppSource for more details.

  • UX Improvements for AI Table Assistant - The Table AI Assist tool includes the ability to edit recipes, has auto-save of recipes, UX improvements such as showing new column header in italics.

    See The Table AI Assist Tool for more details.

  • Live Feed Reporting enhancements: Using the existing Simple Mail Transfer Protocol (SMTP) email registration setup in the Live Feed, you receive email when:
    • New rows are added: You receive email notifications when Live Feed runs and loads your table with new data.
    • Data Validation Issues Occur: You receive email notifications when inconsistencies arise, such as when the tool attempts to load non-numeric values into a numeric field.
    • Live Feed throws an Error: You receive email notifications if errors occur such as when the bucket containing your files is deleted or your credential for that bucket was dropped.

    See Send Email using Live Feed Tool for more details.

Long Pending Transaction Event

The LongPendingTransaction event is generated when a transaction is open for longer than 24 hours.

See Information Events on Autonomous AI Database for more information.

Recovery Time Objective (RTO) for a Cross-region Autonomous Data Guard Standby

The Recovery Time Objective (RTO) for cross-region Autonomous Data Guard Standby databases is lowered to less than ten (10) minutes.

See Autonomous Data Guard Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for more information.

Documentation Addition: Automatic Regression Detection

Automatic Regression Detection in Autonomous AI Database provides proactive handling of regressions and enables automated issue detection, diagnosis, and mitigation. 

See About Scheduled Maintenance and Patching for more information.

Average Active Sessions and Session Utilization Metrics

The AverageActiveSessions metric shows the average number of sessions that are actively executing or waiting for resources. The SessionUtilization metric shows the maximum session utilization.

See Available Metrics: oci_autonomous_database for more information.

Credential Comments in DBMS_CLOUD.CREATE_CREDENTIAL

The DBMS_CLOUD.CREATE_CREDENTIAL procedure supports comments when you use the comments parameter.

See Create Credentials to Access Cloud Services and CREATE_CREDENTIAL Procedure for more information.

Migration from PostgreSQL, MySQL, or SQL Server to Oracle SQL

You can migrate SQL statements from PostgreSQL, MySQL, or SQL Server, to Oracle SQL and run the statements on Autonomous AI Database.

See Migrate Applications from Non-Oracle SQL to Oracle SQL for more information.

Documentation Change: Pre-Authenticated Request (PAR) URLs Renamed to Table Hyperlinks

You can generate and manage Table Hyperlinks to access data on Autonomous AI Database.

See Use Table Hyperlinks for Read Only Data Access on Autonomous AI Database for more information.

Additional File Types Supported for Select AI RAG Vector Index Creation

Select AI Retrieval Augmented Generation (RAG) supports multiple file formats, including PDF, DOCX, JSON, XML, and HTML, among others.

For more information, see Select AI with Retrieval Augmented Generation (RAG) and, for the complete list of supported file formats, Build your Vector Store.

March 2025

Feature Description

Elastic Pool with Any Workload Leader

When you create an elastic pool, the workload type of the leader is not restricted. The workload type of an elastic pool leader can be one of: Transaction Processing, Data Warehouse, JSON, or APEX.

See About Elastic Pools and About Autonomous AI Database Workload Types for more information.

SQL Parse Error Warning Event: SQLParseErrorWarning

If a SQL parse error occurs several times in a certain time window, for example 200 times or more in an hour, this generates "Too Many Parse Errors" entries in the alert log. The SQLParseErrorWarning event is triggered when there is a new entry in the alert log, indicating that a SQL statement has too many parse errors. For example, when an invalid query runs 200 times in less than an hour, this triggers the SQLParseErrorWarning event.

See Information Events on Autonomous AI Database for more information.

Create Refreshable Clone with 19c Source and 23ai Refreshable Clone

When you create a refreshable clone from an Oracle Database 19c source, you can select Oracle AI Database 26ai for the refreshable clone. You can use the refreshable clone to test your database on Oracle AI Database 26ai. After your testing is complete, you can disconnect the refreshable clone to upgrade to Oracle AI Database 26ai.

See Upgrade an Autonomous AI Database Instance to Oracle AI Database 26ai and Create a Refreshable Clone for an Autonomous AI Database Instance for more information.

Offload Queries from Elastic Pool Leader to Member Refreshable Clones: Includes Queries from PL/SQL and from Oracle Scheduler Jobs

When you have heavy read workloads, where a relatively small amount of data is scanned by multiple queries, including from PL/SQL or from Oracle Scheduler Jobs, you can offload queries (reads) from an elastic pool leader to Refreshable Clones.

See Offload Queries to Member Refreshable Clones for more information.

Connections Dropped Metrics

The ConnectionsDroppedByClient metric shows the sum of the number of connections dropped by the client. The ConnectionsDroppedByServer metric shows the sum of the number of connections dropped by the server.

See Available Metrics: oci_autonomous_database for more information.

Oracle APEX 24.2

Autonomous AI Database uses Oracle APEX Release 24.2.

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

Data Studio Enhancements

The Data Studio is updated with new features and changes:

  • The Table AI Assist Tool: The Data Studio suite of tools now features an AI-powered Table Assist Tool to effortlessly enhance your local data tables with the power of AI. You can use natural language prompts to augment and correct your information with this tool.

    See The Table AI Assist Tool for more information.

  • Catalog Tool Enhancements: The new multi-catalog capabilities of the Autonomous Database catalog mean you can add catalogs to enable data search, discovery and use across a wide range of external systems, including other Autonomous Databases, on-premises databases, cloud storage systems, shared data, and other data catalogs such as Oracle Cloud Infrastructure Data Catalog and AWS Glue.

    See The Catalog Tool for more information.

  • The Data Marketplace Tool: Using Data Studio Marketplace, Autonomous Database users can easily collaborate by sharing data with other users of the same or another Autonomous Database. Data providers publish data sets in just minutes, no coding required. Data consumers can browse available data sets, and query live data or copy it to their own Autonomous Database Instance.

    See The Data Marketplace Tool for more information.

  • Data Load Livefeed Enhancements:

    • With the new Basic mode, creating a Livefeed is as simple as selecting a folder from a drop-down menu.
    • New ability to use Merge semantics in livefeeds. The Livefeed feature automatically updates existing data in your tables with new information, eliminating redundant rows and ensuring data integrity.
    • With newly introduced Show code icon, you can view the underlying SQL code behind your livefeeds and even run the code manually in the SQL worksheet.

    See Feeding Data for more information.

Documentation Addition: Migrate Existing SQL Execution Plans to Autonomous Database

You can use Real-time SQL Plan Management when you migrate from a source Oracle Database to Autonomous AI Database.

See Migrate Existing SQL Execution Plans to Autonomous AI Database to Mitigate the Risk of SQL Performance Regressions for more information.

February 2025

Feature Description

Offload Queries from Elastic Pool Leader to Member Refreshable Clones

When you have heavy read workloads, where a relatively small amount of data is scanned by multiple queries, you can offload queries (reads) from an elastic pool leader to Refreshable Clones.

See Offload Queries to Member Refreshable Clones for more information.

Create External Tables Over PAR URLs

You can create an external table over Pre-Authenticated Request (PAR) URLs.

See Query Data that Uses Table Hyperlink Source for more information.

Update Cloud Links Registrations

With Cloud Links, a data owner registers a table or view for remote access for a selected audience as defined by the data owner, and the data is then accessible to those with access granted at registration time. After you register a data set you can update data set attributes.

See Update Data Set Registration Attributes for more information.

Database User Password Warning Event: DatabaseUserPasswordWarning

The database user password warning event provides a message that the Autonomous AI Database user password is expiring within the specified grace period (default 30 days) or has already expired.

See Critical Events on Autonomous AI Database for more information.

January 2025

Feature Description

Documentation Addition: Create and Use Custom Metrics

You can create custom metrics to collect, publish, and analyze metrics. A custom metric collects specified data from your Autonomous AI Database instance and publishes the data to the OCI Monitoring service using a REST API provided by the OCI SDK.

See Use Custom Metrics on Autonomous AI Database for more information.

Disconnect a Peer Database

You can disconnect an Autonomous Data Guard standby or a Backup-Based Disaster Recovery peer. When you disconnect a cross-region peer, the database is permanently disassociated from the Primary database. This converts the database from a peer database to a standalone database.

See Disconnect a Peer Database for more information.

Change Patch Level After Provisioning

When you provision or clone an Autonomous AI Database instance you can select a patch level to apply to upcoming patches. You can also change the patch level after an Autonomous AI Database instance is provisioned. There are two patch level options: Regular and Early.

See Set the Patch Level for more information.

Service Name Mapping for Cloud Links Consumers

You can set the service name mapping to use when Cloud Links consumers access data from a data set owner.

See Set Database Service Name Mapping for Cloud Links Consumers for more information.

External Tables with ORC, Parquet, and Avro Provide an Option to Set Size of String Columns

When you access ORC, Parquet, or Avro data stored in object store using external tables, you can either automatically or explicitly set the maximum size of text columns. By default the text column size is set based on the value of MAX_STRING_SIZE.

See Query External Data with ORC, Parquet, or Avro Source Files and Explicitly Set the Text Column Size for more information.

Invoke Google Cloud Platform Cloud Run Functions

You can invoke Google Cloud Platform Cloud Run functions as SQL functions.

See Steps to Invoke Google Cloud Run Functions as SQL Functions for more information.

2024 What's New

Announcements for the noteworthy changes made to Oracle Autonomous AI 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 AI Database does not allow changes to the retention period for automatic backups.

See About Backup and Recovery on Autonomous AI 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 AI 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 AI 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 AI 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 Create a Table Hyperlink 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 AI Database over the previous 24 hours has exceeded 50% of the average incoming or outgoing traffic.

See Information Events on Autonomous AI Database for more information.

Maintenance Window Details on OCI Console

The Oracle Cloud Infrastructure Console Autonomous AI 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 AI Database Oracle-managed heterogeneous connectivity to create database links to Microsoft SharePoint. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI Database for more information.

Select AI with Hugging Face

Autonomous AI 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 AI Database on a private endpoint, that you assign security attributes to.

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

Select AI with Anthropic

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

See Undelete a Terminated Autonomous AI Database Instance for more information.

August 2024

Feature Description

Use Database In-Memory with Autonomous AI Database

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

See Use Database In-Memory with Autonomous AI 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 AI 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 AI Database 26ai

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

See Upgrade to Oracle AI Database 26ai by Creating 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 AI 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 AI Database

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

See Migrate Applications from PostgreSQL Databases to Autonomous AI Database for more information.

Autonomous AI Database 23ai Available in the Paid Tier

Autonomous AI Database with Oracle AI Database 26ai in the Paid tier is available in all commercial public cloud regions.

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

Update for Oracle-Managed Heterogeneous Connectivity Database Links

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

See Use OCI Full Stack Disaster Recovery with Autonomous AI 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 AI 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 AI 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 AI Database instance either with a wallet (mTLS) or without a wallet (TLS).

See Connect Go Applications to Autonomous AI 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 Tool.

  • Data Load support for Boolean data type:

    The Data Load tool now supports loading Boolean data from source files into the new Oracle AI Database 26ai 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 AI Database 23ai Available in the Paid Tier

Autonomous AI Database with Oracle AI Database 26ai in the Paid tier is available in all commercial public cloud regions.

See Provision an Autonomous AI Database Instance and Clone an Autonomous AI 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 Autonomous AI Database 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 AI 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 AI Database.

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

Public Access Allowed for an Autonomous AI Database on a Private Endpoint

When you want to configure an Autonomous AI 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 AI 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 AI Database for more information.

Oracle APEX 24.1

Autonomous AI Database uses Oracle APEX Release 24.1.

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

Documentation Addition: Load Data from Google Cloud Storage

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

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

Shrink Storage for Tables with LONG Columns

Autonomous AI 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 AI Database Oracle-managed heterogeneous connectivity to create database links to YouTube. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous AI 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 Access Data in Table Format with Table Hyperlinks or Table Hyperlink Groups for more information.

Cross-Tenancy Access for IAM Users to Autonomous AI Database

Identity and Access Management (IAM) cross-tenancy user access to an Autonomous AI 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 AI 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 AI Database.

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

Always Free with Oracle AI Database 26ai

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

See Always Free Autonomous AI Database for more information.

Autonomous AI Database Free Container Image with Oracle AI Database 26ai

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

See Use the Autonomous AI 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 AI Database with IAM permissions.

See Cloning Permissions in IAM Permissions and API Operations for Autonomous AI 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 AI 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 AI 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 AI 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 AI Database schemas for a limited time.

See Manage Oracle Cloud Operator Access for more information.

Apache Iceberg External Tables

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

Use Data Sharing to share data, as of the latest database commit, with Autonomous AI 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 AI Database Free Container Image

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

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

March 2024

Feature Description

Refreshable Clone Automatic Refresh Option

When you enable the automatic refresh option Autonomous AI 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 AI Database as SQL functions. You do not install external procedures on Autonomous AI 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 AI 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 AI 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 AI Database and Autonomous AI Database provides views that allow you to monitor PAR URL usage.

See Monitor and View Table Hyperlink Usage for more information.

UTL_HTTP allows HTTP_PROXY Connections

With UTL_HTTP, when the Autonomous AI 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 AI 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 AI Database.

See Use Table Hyperlinks for Read Only Data Access on Autonomous AI 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 AI 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 AI 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 AI Database provides several options to automatically update time zone files.

See Manage Time Zone File Updates on Autonomous AI 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 AI Database instances when you enable Kerberos authentication (you do not need to create and upload different Keytab files for each Autonomous AI Database instance).

See Configure Kerberos Authentication with Autonomous AI Database for more information.

Clone Database to Change Workload Type

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

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

2023 What's New

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

December 2023

Feature Description

Cross Tenancy Cloning

You can clone an Autonomous AI 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 AI 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 AI 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 AI Database to a target Oracle RAC database and specify multiple hostnames.

See Create Database Links from Autonomous AI 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 AI Database instance from AWS S3.

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

November 2023

Feature Description

Oracle APEX 23.2

Autonomous AI Database uses Oracle APEX Release 23.2.

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

Select AI with Azure OpenAI Service

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

Database Links Without a Wallet (TLS)

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

See Create Database Links from Autonomous AI Database to a Publicly Accessible Autonomous AI 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 AI Database billing information.

See How Is Autonomous AI Database Billed? for more information.

Documentation Addition: Oracle Database Migration Information

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

See Migrate Oracle Databases to Autonomous AI Database for more information.

ServiceNow Support for Database Links with Oracle-Managed Heterogeneous Connectivity

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

Elastic Pools

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

See Optimize Costs with Elastic Pools on Autonomous AI Database for more information.

Free Container Image

Use the Autonomous AI Database Free Container Image to run Autonomous AI 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 AI 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 AI Databases provisioned with the Transaction Processing workload type. The minimum storage allowed for an Autonomous AI Database instance in ECPU compute model with Transaction Processing workload is 20 GB.

See Provision an Autonomous AI Database Instance for more information.

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

Use Autonomous AI Database Oracle-managed heterogeneous connectivity to create database links to Google Analytics. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous AI 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 AI 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 AI Database allows you to synchronize with Amazon Web Services (AWS) Glue Data Catalog metadata. You can query data stored in S3 from Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database Views

Using the Oracle Cloud Infrastructure Logging Interface you can access log data from an Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Databases. Using Cloud Links you can access read-only data based on the cloud identities of Autonomous AI Database instances. The scope of collaboration can be the region where an Autonomous AI Database resides, individual tenancies, compartments, or particular Autonomous AI 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 AI Database

Provides information on options for using Oracle Machine Learning with Autonomous AI 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 AI Database instance to another Autonomous AI Database instance. This enables you to compare workloads across different Autonomous AI Database instances. These Autonomous AI 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 AI Database instance.

See Obtain Tenancy Details for more information.

Provision an Autonomous AI Database Instance and Save as Stack

The provisioning option Save as Stack allows you to create and deploy an Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI Database lets you choose to enable the feature that automatically updates time zone files on your Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database.

See Monitor Regional Availability of Autonomous Databases for more information.

July 2022

Feature Description

Use Oracle Java

Autonomous AI 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 AI 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 AI Database allows you to rotate wallets for an Autonomous AI 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 AI 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 AI Database instance. This enables you to compare workloads between an on-premises database or other cloud service database and an Autonomous AI 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 AI 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 AI Database supports using Oracle LogMiner.

See Oracle LogMiner for more information.

Synchronization with Data Catalog Enhancements

Synchronize Data Catalog partitioned metadata with Autonomous AI 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 AI Database to authenticate and authorize Microsoft Active Directory users. The configuration steps are simplified for enabling Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database Availability

You can monitor Autonomous AI 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 AI 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 AI Database to Oracle Databases on a Private Endpoint without a Wallet

You can create database links from an Autonomous AI 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 AI 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 AI 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 AI Database from a standalone Python engine on Linux to connect to Autonomous AI Database as well as 19c and newer Oracle Database releases. This supports working with OML4Py on Autonomous AI Database, local third-party IDEs, and other notebook environments, like JupyterLab. It further allows switching between on-premises and Autonomous AI 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 AI 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 AI 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 AI 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 AI Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database using MongoDB commands.

See Using Oracle Database API for MongoDB for more information.

Oracle Data Miner Access to Autonomous AI Database

Oracle Data Miner in SQL Developer can be used with Oracle Autonomous AI 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 AI Database.

Cross-Region Cloning

When you clone an Autonomous AI 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 AI Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous AI 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 AI 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 AI 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 AI 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 AI Database or a fleet of Autonomous AI 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 AI 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 AI 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 AI 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 AI Database by default supports Mutual TLS (mTLS) connections. You have the option to configure an Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database tools and resources, including: Database Actions, Graph Studio, Oracle APEX, Oracle Machine Learning Notebooks, Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database. When you use ARN role based authentication with Autonomous AI 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 AI 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 AI 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 AI JSON Database

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

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

    See The Data Load Page for more information.

  • Catalog: helps you to see information about the entities in your Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI 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 AI Database

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

Oracle APEX 20.2

Autonomous AI 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 AI Database Events

Autonomous AI Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. Subscribing to Autonomous AI 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 AI 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 AI JSON Database

If your database version is Oracle Database 19c or higher, you can provision an Autonomous AI JSON Database. Autonomous AI 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 AI JSON Database for more information.

Amazon S3-Compatible Object Stores

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

See Rename Autonomous AI Database for more information.

July 2020

Feature Description

Oracle APEX Release 20.1

Autonomous AI Database supports Oracle APEX Release 20.1.

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

If your Autonomous AI 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 AI Database provides the Autonomous Data Guard feature to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous AI 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 AI 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 AI Database network access is configured to use a private endpoint you can change the configuration to use a public endpoint. Likewise, if your Autonomous AI Database instance is configured to use a public endpoint, you can change the configuration to use a private endpoint.

Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI Database to Oracle Database 19c

If your Autonomous AI 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 AI 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 AI 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 AI Databases in Oracle Cloud directly from the IDE.

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

Per-Second Billing

Autonomous AI Database instance CPU and storage usage is billed by the second, with a minimum usage period of 1 minute. Previously Autonomous AI 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 AI Database and allows connections to the Autonomous AI Database instance. The NSG can now be configured with stateful rules.

See Configure Private Endpoints with Autonomous AI Database for more information.

Wallet zip File Contains README File

The wallet file that contains client credentials (wallet files) for your Autonomous AI 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 AI Database instance

Use Restart to restart an Autonomous AI Database instance.

See Restart Autonomous AI 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 AI 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 AI Database to Oracle Database 19c

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

Oracle Database Versions by Region

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

Oracle Application Express Release 19.2

Autonomous AI 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 AI 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 AI 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 AI 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 AI 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 AI Database Serverless Deployment in the year 2019.

December 2019

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

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

See Use an Access Control List with Autonomous AI 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 AI Database Information tab shows the schedule for upcoming maintenance.

See About Autonomous AI 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 AI Database that allows you to test your applications and to become familiar with features in the next release of Autonomous AI 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 AI 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 AI 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 AI Database. You can view real-time and historical performance data from the Performance Hub.

See Monitor Autonomous AI Database with Performance Hub for more information.

Oracle Cloud Infrastructure Native Object Store Authentication

Autonomous AI 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 AI 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 AI 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 AI Database now supports Microsoft Azure cloud storage with Oracle Data Pump.

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

See Restrictions for Oracle XML DB for more information.

Modify CPU/IO Shares from Service Console

Autonomous AI 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 AI Database now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous AI 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 AI 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 AI 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 AI Database provides cloning where you can choose to clone either the full database or only the database metadata.

See Cloning a Database with Autonomous AI 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 AI Lakehouse and Autonomous AI 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 AI Database.

See Workload Types for more information.

Service Gateway

You can now set up a Service Gateway with Autonomous AI Database. A service gateway allows connectivity to Autonomous AI 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 AI 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 AI 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 AI Database Serverless Deployment in the year 2018.

October 2018

Feature Description

Oracle Cloud Infrastructure Console changes

The Autonomous AI Database console has a new layout and provides new buttons that improve the usability of Autonomous AI 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 AI 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 AI Database.

July 2018

Feature Description

SQL Developer 18.2.0 and later without Keystore Password field for connections

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

You can also remove files from the local file system. See DELETE_FILE Procedure.