Database: Autonomous Database Serverless
47 Release Notes
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.
Select AI enhancements
Select AI includes the following new features.
Data Transforms updates
Data Transforms is updated with new features and changes in the following areas.
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 Database 23ai instance with Select AI RAG to generate vector embeddings for document chunks and user prompts.
Data Studio enhancements
The Data Studio is updated with new features and changes.
Long Pending Transaction event
The LongPendingTransaction event is generated when a transaction is
open for longer than 24 hours.
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.
Automatic Regression Detection
Automatic Regression Detection in Autonomous Database provides proactive handling of regressions and enables automated issue detection, diagnosis, and mitigation.
Average Active Sessions and Session Utilization metrics
The AverageActiveSessions metric shows the average number of
sessions that are actively executing or waiting for resources.
Support for comments parameter in the CREATE_CREDENTIAL procedure
The DBMS_CLOUD.CREATE_CREDENTIAL procedure
supports comments when you use the comments parameter.
Migrate statements 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 in Autonomous Database.
Pre-Authenticated Request (PAR) URLs renamed to "Table Hyperlinks"
You can generate and manage Table Hyperlinks to access data in Autonomous Database.
Support for additional file types in 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.
Create and use custom metrics
You can create custom metrics to collect, publish, and analyze metrics.
Disconnect a peer database
You can disconnect an Autonomous Data Guard standby or a Backup-Based Disaster Recovery peer.
Change patch level after provisioning
When you provision or clone an Autonomous Database instance you can select a patch level to apply to upcoming patches.
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.
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.
Invoke Google Cloud Platform Cloud Run functions
You can invoke Google Cloud Platform Cloud Run functions as SQL functions.
Autonomous Database on shared Exadata infrastructure: mutual TLS (mTLS) connections
Autonomous Database by default supports Mutual TLS (mTLS) connections. You have the option to configure an Autonomous Database instance to ...
OCI Vault Integration with Autonomous Database on Shared Exadata Infrastructure (ADB-S)
Autonomous Database on Shared Exadata Infrastructure (ADB-S) integrated with Oracle Cloud Infrastructure Vault provides data encryption using a customer-managed encryption ...
Maintenance advisory contacts for Autonomous Databases on shared Exadata Infrastructure
You can choose to specify up to 10 valid email addresses to which Oracle sends maintenance notifications when updates are ...
Maintenance History for Autonomous Databases on Shared Exadata Infrastructure
You can view the maintenance history for a specific Autonomous Database on shared Exadata infrastructure. See Checking the Scheduling of ...
Autonomous Database now offers refreshable clones
You can now create a refreshable clone of an Autonomous Database deployed on shared Exadata infrastructure. With a refreshable clone, ...
Performance Hub Blocking Sessions Tab
The Performance Hub Blocking Sessions Tab is now avaialble for Autonomous Databases on both shared Exadata Infrastructure and dedicated Exadata ...
Oracle Autonomous Databases on shared Exadata Infrastructure support private endpoints for Data Safe
Oracle Autonomous Databases running on shared Exadata infrastructure and using private endpoints are now compatible with Data Safe. For ...
Autonomous JSON Database
Autonomous JSON Database is a service added to Autonomous Database services that you can deploy on shared Exadata infrastructure. Autonomous ...
Rename Autonomous Database on shared Exadata infrastructure
You can rename an Autonomous Database on shared Exadata infrastructure. For more information, see To rename an Autonomous Database on ...
Provision a standby Autonomous Database on shared Exadata infrastructure using Autonomous Data Guard
You can now provision a standby (peer) Autonomous Database on shared Exadata infrastructure for data protection and disaster recovery using ...
Autonomous Database network access: in-place switch to a private endpoint now available for databases using shared Exadata infrastructure
You can now perform an in-place update of your Autonomous Database network access configuration to switch to a private endpoint. ...
Events for Autonomous Database on shared Exadata infrastructure: 19C database version upgrade
Two additional Autonomous Database events are now available:
- Upgrade Begin
- Upgrade End
These events are ...
Autonomous Databases with shared Exadata infrastructure now use per-second billing
Autononomous Databases using shared Exadata infrastructure now use per-second billing, with a minimum usage of 60 seconds. This replaces hourly ...
Upgrade Autonomous Databases on shared Exadata infrastructure to Oracle Database 19c
Autonomous Databases on shared Exadata infrastructure can now be upgraded to Oracle Database 19c. For more information, see To upgrade ...
Autonomous Database with shared Exadata infrastructure: "restart" button and API
You can now restart an Autonomous Database that uses shared Exadata infrastructure by clicking a single button in the console, ...
Private endpoint for Autonomous Database with shared Exadata infrastructure
For Autonomous Databases using shared Exadata infrastructure, you can now provision the database with a private network endpoint within your ...
Autonomous Database with shared Exadata infrastructure: Choice of Oracle Database versions at provisioning
Depending on the region where you provision or clone your database, Autonomous Database supports one or more Oracle Database versions. ...
Autonomous Database: Maintenance Schedule Details Available in Console (serverless deployments)
Autonomous Databases with serverless deployment now display scheduling details for the next maintenance run in the Oracle Cloud Infrastructure Console. ...
Autonomous Database: Add VCNs and private IP addresses to Access Control Lists (serverless deployments)
You can now add VCNs to your Autonomous Database's Access Control List (ACL). This applies to serverless deployments only. You ...
Autonomous Database: Enhancement for Wallet for Serverless Deployments
For Autonomous Databases with serverless deployment, you now have the choice of downloading either a single database instance wallet or ...
Work requests available for Autonomous Databases
Auto scaling Autonomous Databases
Autonomous Database's auto scaling feature enables the system to automatically adjust the number of CPU cores as load demand fluctuates, ...
Access control lists for Autonomous Databases
You can now create an access control list (ACL) for your Autonomous Database after you provision it by using the ...
Updating license type for Autonomous Databases
You can now change your license type for your Autonomous Database after you provision it by using the Oracle Cloud ...
Cloning Autonomous Databases
You can now clone an Autonomous Database by using the Oracle Cloud Infrastructure Console or the API. For information and ...
Unified list of Autonomous Databases in the Console and API
In the Console, Autonomous Transaction Processing databases and Autonomous Data Warehouse databases now appear in a common list of Autonomous ...
Autonomous Transaction Processing
Oracle Cloud Infrastructure's Autonomous Transaction Processing gives you your own fully managed, pre-configured transaction processing database environment, without the need ...
Autonomous Data Warehouse
Oracle Cloud Infrastructure's Autonomous Data Warehouse gives you your own fully managed, pre-configured data warehousing environment, without the need to ...