Database: Autonomous Database Serverless

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.

You can invoke Python scripts with the WITH_CONTEXT attribute from an Autonomous AI Database instance.

External Table Cache in Autonomous AI Database enables you to cache frequently accessed data from external tables in your database.

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

Oracle AI Database architects Artificial Intelligence (AI) into its core, seamlessly integrating AI across all major data types and workloads.

Autonomous Data Guard can be enabled for elastic pools with local standbys.

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.

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.

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

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.

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

Use the DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure to create implicit partitioned external tables.

You can now use Select AI for Python to access DBMS_CLOUD_AI capabilities in Autonomous AI Database from Python applications.

Select AI supports customizable conversations enabling you to use Select AI with different topics without mixing context, improving both flexibility and efficiency.

Select AI enables you to give feedback on generated NL2SQL results to improve query generation accuracy.

Select AI enables you to generate a summary of your text directly in a prompt or from a URI.

You can generate a Table Hyperlink with ACL checking enabled.

Data Transforms includes the following new features and changes.

You can use directory files, including those in network file systems, with data pipelines and the SELECT AI vector index in Autonomous Database.

You can use wildcard 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 Database.

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

You can create a password-protected Table Hyperlink by specifying a Table Hyperlink password.

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

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

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.

Autonomous Database introduced new dataplane events, UnplannedMaintenanceBegin and UnplannedMaintenanceEnd.

Query the DBA_NONJSON_OBJECTS view to assess the space consumed by non-JSON objects on an Autonomous Database instance.

View the available elastic pool capacity.

If your Autonomous Database instance is using Oracle Database 19c, you can upgrade to Oracle Database 23ai with scheduled upgrade.

External table cache in Autonomous Database enables you to cache frequently accessed data from external tables in your database.

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

Substitution variables are pre-defined placeholders which are resolved and substituted with the corresponding actual values based on the runtime context of your Autonomous Database.

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.

You can invoke generic scripts, of type BASH, C, or Python from an Autonomous Database instance.

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

Select AI extends its support to the following AI providers:

The view V$DIAG_ALERT_EXT is not available for alert log data.

The Data Studio is updated with new features and changes.

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

Table Hyperlink Groups allow you to access data from multiple objects or multiple SQL SELECT statements through a single URL.

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

Autonomous Database patches are applied during a scheduled maintenance window as rolling patches.

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

You can combine Organization Management with the benefits of elastic pools.

You can generate a Table Hyperlink with ACL checking enabled.

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

Critical events and Information events include an eventCategory attribute.

You can access external data by mounting catalogs and querying them using a simplified SQL syntax.

Select AI includes the following new features.

A cross-region standby can be added to an elastic pool or can be an elastic pool leader.

Use Autonomous Database Oracle-managed heterogeneous connectivity to create database links to Google Drive.

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.

Elastic pool cost and usage details are recorded in the Oracle Cloud Infrastructure cost reports and in the OCI_COST_DATA view.

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.

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

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

DBMS_CLOUD supports loading and querying data using external tables as well as exporting and importing of data from Autonomous Database to object storage.

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.

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

Select AI includes the following new features.

You can use in-database transformers (also known as embedding models) that you imported into your Oracle Database 23ai instance with Select AI RAG to generate vector embeddings for document chunks and user prompts.

The Data Studio is updated with new features and changes.

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

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

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

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

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

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

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

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

When you create an elastic pool, the workload type of the leader is not restricted.

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.

When you create a refreshable clone from an Oracle Database 19c source, you can select Oracle Database 23ai for the refreshable clone.

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.

Two new metrics are introduced for the Database service in the oci_autonomous_database namespace.

The APEX instances in Autonomous Database Serverless (including APEX Service) are upgraded to Oracle APEX 24.2.

The Data Studio is updated with new features and changes.

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

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.

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

With Cloud Links, a data owner registers a table or view for remote access for a selected audience as defined by the data owner.

Autonomous Database introduced a new data plane event, DatabaseUserPasswordWarning.

You can create custom metrics to collect, publish, and analyze metrics.

You can disconnect an Autonomous Data Guard standby or a Backup-Based Disaster Recovery peer.

When you provision or clone an Autonomous Database instance you can select a patch level to apply to upcoming patches.

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

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.

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