Database: Autonomous Database Serverless

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.