Previous Feature Announcements
Announcements for the important changes made to Oracle Autonomous Database Serverless.
See What’s New for Oracle Autonomous Database Serverless for feature announcements in 2023.
- 2023 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2023. - 2022 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2022. - 2021 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2021. - 2020 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2020. - 2019 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2019. - 2018 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2018.
Parent topic: Reference
2023 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2023.
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- January 2023
- February 2023
Parent topic: Previous Feature Announcements
December 2023
| Feature | Description |
|---|---|
|
Cross Tenancy Cloning |
You can clone an Autonomous 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 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 Database as SQL functions. See Steps to Invoke Azure Function as SQL Functions for more information. |
|
Create Database Links to Oracle RAC Database |
You can create database links from an Autonomous Database to a target Oracle RAC database and specify multiple hostnames. See Create Database Links from Autonomous 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 Database instance from AWS S3. See Load Data into Autonomous Database from AWS S3 for more information. |
Parent topic: 2023 What's New
November 2023
| Feature | Description |
|---|---|
|
Oracle APEX 23.2 |
Autonomous Database uses Oracle APEX Release 23.2. See Create Applications with Oracle APEX in Autonomous Database for more information. |
|
Select AI with Azure OpenAI Service |
Autonomous Database can interact with AI service providers. Select AI now supports the Azure OpenAI Service, OpenAI, and CohereAI. One way LLMs can work with Oracle database is by generating SQL from natural language prompts that allow you to talk to your database. See Use Select AI to Generate SQL from Natural Language Prompts for more information. |
|
Break Glass Access with |
Autonomous Database supports break glass access for SaaS providers. Break glass access allows a SaaS operations team, when explicitly authorized by a SaaS customer, to access a customer's database to perform critical or emergency operations. See Break Glass Access for SaaS on Autonomous Database for more information. |
|
Database Links Without a Wallet (TLS) |
You can create database links from one Autonomous Database instance to a publicly accessible Autonomous Database without a wallet (TLS). See Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database without a Wallet (TLS) for more information. |
Parent topic: 2023 What's New
October 2023
| Feature | Description |
|---|---|
|
Vault Secret Credential Objects |
You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required). Supported vaults are:
See Use Vault Secret Credentials for more information. |
|
Documentation Addition: Billing Information |
Documentation includes summary and detailed Autonomous Database billing information. See How Is Autonomous Database Billed? for more information. |
|
Documentation Addition: Oracle Database Migration Information |
Documentation includes information on migrating your Oracle Database to Autonomous Database. See Migrate Oracle Databases to Autonomous Database for more information. |
|
ServiceNow Support for Database Links with Oracle-Managed Heterogeneous Connectivity |
Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to ServiceNow. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection. See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information. |
|
Invoke Oracle Cloud Infrastructure Functions or AWS Lambda Remote Functions |
You can invoke Oracle Cloud Infrastructure Functions and AWS Lambda remote functions in your Autonomous Database as SQL functions. See Invoke User Defined Functions for more information. |
Parent topic: 2023 What's New
September 2023
| Feature | Description |
|---|---|
|
Use Select AI to Generate SQL from Natural Language Prompts |
Autonomous Database can interact with AI service providers including: OpenAI and CohereAI to provide access to Generative AI capability from Oracle Database that uses Large Language Models (LLMs). One way LLMs can work with Oracle database is by generating SQL from natural language prompts that allow you to talk to your database. See Use Select AI to Generate SQL from Natural Language Prompts for more information. |
|
Cloud Links Usability and Security |
Cloud Links provide a cloud-based method to collaborate between Autonomous Databases. Cloud Links now allow you to set a data set owner. Cloud Links can be configured to require an additional authorization step, where a data set only allows specified databases to access the data set. When you register a data set, you can also specify refreshable clones to offload access to the data set. See Use Cloud Links for Read Only Data Access on Autonomous Database for more information. |
| Elastic Pools |
Use an elastic pool to consolidate your Autonomous Database instances, in terms of their allocation of compute resources, and to provide up to 87% cost savings. See Use and Manage Elastic Pools on Autonomous Database for more information. |
|
Autonomous Database Free Container Image |
Use the Oracle Autonomous Database Free Container Image to run Autonomous Database in a container in your own environment, without requiring access to the Oracle Cloud Infrastructure Console or to the internet. See Use the Oracle Autonomous Database Free Container Image for more information. |
| ECPU-based Databases with Transaction Processing Workload Type Support per-Gigabyte Increments of Storage |
You may now provision, clone, and scale using Gigabyte (GB) increments of storage for ECPU-based Autonomous Databases provisioned with the Transaction Processing workload type. The minimum storage allowed for an Autonomous Database instance in ECPU compute model with Transaction Processing workload is 20 GB. See Provision Autonomous Database for more information. |
|
Google Analytics Support for Database Links with Oracle-Managed Heterogeneous Connectivity |
Use Autonomous Database Oracle-managed heterogeneous connectivity to create database links to Google Analytics. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection. See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information. |
Parent topic: 2023 What's New
August 2023
| Feature | Description |
|---|---|
|
|
You can use the subprograms and views in the
See DBMS_SHARE Package for more information. |
|
Logical Partition Change Tracking (LPCT) |
Logical Partition Change Tracking enables you to create logical partitions on base tables. It evaluates the staleness of the base tables for individual logical partitions without using a materialized view log or requiring any of the tables used in the materialized view to be partitioned. Logical Partition Change Tracking provides the capability to leverage the user-supplied logical partitioning information of base tables of materialized view for a more fine-grained, partition-level tracking of stale data for both refresh and rewrite purposes. While classical Partitioning Change Tracking (PCT) relies on the physical partitioning of tables, LPCT has no dependency on tables being physically partitioned; you can use LPCT with both partitioned and nonpartitioned tables. See Logical Partition Change Tracking and Materialized Views for more information. |
|
Update OCPU to ECPU Compute Model |
You can update an Autonomous Database instance from the OCPU billing model to the ECPU billing model. See Update to ECPU Billing Model on Autonomous Database for more information. |
|
Choose Backup Retention Period with ECPU Compute Model |
With the ECPU billing model you have the option to select the backup retention period for automatic backups, with a retention period between 1 day and up to 60 days. See Edit Automatic Backup Retention Period on Autonomous Database for more information. |
|
AWS Glue Data Catalog Integration |
Autonomous Database allows you to synchronize with Amazon Web Services (AWS) Glue Data Catalog metadata. You can query data stored in S3 from Autonomous Database without having to manually derive the schema for the external data sources and create external tables. See Query External Data with AWS Glue Data Catalog for more information. |
Parent topic: 2023 What's New
July 2023
| Feature | Description |
|---|---|
|
Track Table Changes with Flashback Time Travel |
Use Flashback Time Travel to view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. See Tracking Table Changes with Flashback Time Travel for more information. |
|
Database Actions Quick Links |
Database Actions on the Oracle Cloud Infrastructure Console provides quick links to select Database Actions cards or to select the Database Actions Launchpad. See Access Database Actions as ADMIN for more information. |
|
Object Storage and REST Endpoint Management |
See DBMS_CLOUD Endpoint Management for more information. |
|
|
The See DBMS_CLOUD Package Format Options for more information. |
|
Vault Secret Credential Objects |
You can create vault secret credentials with secrets stored in Oracle Cloud Infrastructure Vault. You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required). See Use Vault Secret Credentials for more information. |
|
Export to Directory with |
Export files as text or as Oracle Data Pump dump files to a directory. See Export Data to a Directory for more information. |
Parent topic: 2023 What's New
June 2023
| Feature | Description |
|---|---|
|
Oracle Cloud Infrastructure Signing Key Based Authentication for Oracle Data Pump Import |
Oracle Data Pump import using See Import Data Using Oracle Data Pump on Autonomous Database for more information. |
|
Configurable Automatic Failover Data Loss Limit for a Local Standby Database |
For Autonomous Data Guard you can specify an automatic failover data loss limit between 0 and 3600 seconds. Autonomous Data Guard performs automatic failover to a local standby database when a local standby database is available and the system can guarantee either the default zero data loss RPO or up to the data loss limit you specify. See Automatic Failover with a Standby Database for more information. |
|
Oracle Workspace Manager |
Oracle Workspace Manager provides an infrastructure that enables applications to create workspaces and group different versions of table row values in different workspaces. Use Oracle Workspace Manager to version-enable one or more user tables in the database. See Using Oracle Workspace Manager on Autonomous Database for more information. |
|
Automatic Failover Begin and Automatic Failover End Events |
The
See About Critical Events on Autonomous Database for more information. |
|
Operator Access Event |
The Autonomous Database operations team never access your data unless you explicitly grant permission through a Service Request for a specified duration. See Information Events on Autonomous Database for more information. |
|
Built-in Tool Availability Service Level Objective (SLO) |
Oracle will use commercially reasonable efforts to have the listed built-in tools meet the Availability objectives as defined in Service Level Objective (SLO) documentation. See Availability Service Level Objectives (SLOs) for more information. |
| CMU-AD with Active Directory Servers on a Private Endpoint |
There are now two options for configuring Autonomous Database with Centrally Managed Users (CMU) with Microsoft Active Directory:
See Use Microsoft Active Directory with Autonomous Database for more information. |
Parent topic: 2023 What's New
May 2023
| Feature | Description |
|---|---|
|
Oracle APEX 23.1 |
Autonomous Database uses Oracle APEX Release 23.1. See Creating Applications with Oracle APEX in Autonomous Database for more information. |
|
Google BigQuery Support for Database Links with Oracle-Managed Heterogeneous Connectivity |
Autonomous Database support for Oracle-managed heterogeneous connectivity to create database links to Google BigQuery. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection. See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information. |
|
Log File Options for |
See DBMS_CLOUD Package Format Options for more information. |
|
|
Set the See RESULT_CACHE_MODE for more information. |
|
Stripe Financial Views |
Stripe is an online payment processing and credit card processing
platform for businesses. The Stripe views allow you to query
views created on top of Stripe APIs with See Stripe Views on Autonomous Database for more information. |
|
Oracle GoldenGate Parallel Replicat (Integrated Mode) |
Integrated Parallel Replicat (iPR) supports GoldenGate replication apply for procedural replication, Automatic CDR, and DML handlers. See Deciding Which Apply Method to Use and About Parallel Replicat for more information. |
|
Persistent Messaging in |
The See Use Persistent Messaging with Messages Stored in Cloud Object Store for more information. |
|
Access Oracle Cloud Infrastructure Logging Data with Autonomous Database Views |
Using the Oracle Cloud Infrastructure Logging Interface you can access log data from an Autonomous Database instance, in relational format. You can query log data in Oracle Cloud Infrastructure across all compartments and regions. See Oracle Cloud Infrastructure Logging Interface Views for more information. |
Parent topic: 2023 What's New
April 2023
| Feature | Description |
|---|---|
|
Oracle Spatial Features for Geocoding Address Data and Reverse Geocoding Location Data |
Oracle Spatial on Autonomous Database includes features for geocoding address data and for reverse geocoding longitude/latitude data to a street address. See Using Oracle Spatial with Autonomous Database for more information. |
|
Kerberos Authentication for CMU-AD |
You can configure Autonomous Database to use Kerberos authentication for CMU with Microsoft Active Directory users. This configuration allows CMU Active Directory (CMU-AD) users to access an Autonomous Database instance using Kerberos credentials. |
|
User Defined Notification Handler for Scheduler Jobs |
Database Scheduler provides an email notification mechanism to track the status of periodically running or automated jobs. In addition to this, the Database Scheduler also supports user-defined PL/SQL Scheduler job notification handler procedure. Adding a scheduler job notification handler procedure allows you to monitor scheduled or automated jobs running in your Autonomous Database. See User Defined Notification Handler for Scheduler Jobs for more information. |
|
Database Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle Databases on a Private Endpoint |
You can create database links from an Autonomous Database to an customer-managed Oracle Database Gateway to access Non-Oracle databases that are on a private endpoint. See Create Database Links with Customer-Managed Heterogeneous Connectivity to Non-Oracle Databases on a Private Endpoint for more information. |
|
Oracle Machine Learning Notebooks Early Adopter |
Oracle Machine Learning Notebooks Early Adopter is an enhanced web-based notebook platform for data engineers, data analyst, R and Python users, and data scientists. You can write code, text, create visualizations, and perform data analytics including machine learning. Notebooks work with interpreters in the back-end. In Oracle Machine Learning, notebooks are available in a project within a workspace, where you can create, edit, delete, copy, move, and even save notebooks as templates. See Get Started with Notebooks Early Adopter for Data Analysis and Data Visualization for more information. |
|
Salesforce Support for Database Links with Oracle-Managed Heterogeneous Connectivity |
Autonomous Database support for Oracle-managed heterogeneous connectivity to create database links to Salesforce databases. When you use database links with Oracle-managed heterogeneous connectivity, Autonomous Database configures and sets up the connection. See Create Database Links to Non-Oracle Databases with Oracle-Managed Heterogeneous Connectivity for more information. |
|
Snapshot Standbys for Cross-Region Disaster Recovery |
A disaster recovery cross-region peer can be converted to a snapshot standby. This converts either an Autonomous Data Guard cross-region standby database or a cross-region Backup-Based Disaster Recovery peer to a read-write database for up to two days. See Convert Cross Region Peer to Snapshot Standby for more information. |
Singleton Pipe in
DBMS_PIPE |
Singleton Pipe is an addition to the
See Caching Messages with Singleton Pipes for more information. |
|
Migrate Databases Across Regions with Minimal Downtime Using Autonomous Data Guard |
You may now terminate, as well as perform all other Primary database actions on a remote Autonomous Data Guard standby when it becomes the Primary database, after a switchover or after a failover. This enables you to use a remote peer for migrating your database to the remote region. See Using Standby Databases with Autonomous Data Guard for Disaster Recovery for more information. |
| Send Microsoft Teams Notifications |
Use Microsoft Teams notifications. You can send messages, alerts, or the output of a query from Autonomous Database to a Microsoft Teams Channel. See Send Microsoft Teams Notifications from Autonomous Database for more information. |
Send Email Using
DBMS_CLOUD_NOTIFICATION |
You can send email to a public SMTP endpoint using the Oracle Cloud Infrastructure Email Delivery service. See Send Email from Autonomous Database Using DBMS_CLOUD_NOTIFICATION for more information. |
Parent topic: 2023 What's New
March 2023
| Feature | Description |
|---|---|
|
Cloud Links |
Cloud Links provide a cloud-based method to collaborate between Autonomous Databases. Using Cloud Links you can access read-only data based on the cloud identities of Autonomous Database instances. The scope of collaboration can be the region where an Autonomous Database resides, individual tenancies, compartments, or particular Autonomous Database instances. See Using Cloud Links for Read Only Data Access on Autonomous Database for more information. |
|
Backup-Based Disaster Recovery |
Backup-Based Disaster Recovery uses backups to instantiate a peer database at the time of switchover or failover. For local Backup-Based Disaster Recovery, existing local backups are utilized and there are no additional costs. Cross-Region Backup-Based Disaster Recovery is also available and incurs additional costs. See Using Backup-Based Disaster Recovery for more information. |
|
Documentation Addition: Oracle Machine Learning with Autonomous Database |
Provides information on options for using Oracle Machine Learning with Autonomous Database. See Machine Learning with Autonomous Database for more information. |
|
Export Data to Cloud Object Storage as Parquet |
Use See Export Data to Object Store as Text (CSV, JSON, Parquet, or XML) for more information. |
|
Oracle Real Application Testing Capture and Replay |
Use Capture and Replay from one Autonomous Database instance to another Autonomous Database instance. This enables you to compare workloads across different Autonomous Database instances. These Autonomous Database instances may vary at patch levels, database versions, or regions. See Using Oracle Real Application Testing for more information. |
|
Availability Domain Information |
You can obtain tenancy details, including the Availability Domain (AD) for an Autonomous Database instance. See Obtain Tenancy Details for more information. |
|
Provision an Autonomous Database Instance and Save as Stack |
The provisioning option Save as Stack allows you to create and deploy an Autonomous Database instance using Resource Manager. See Provision Autonomous Database and Overview of Resource Manager for more information. |
|
Oracle Client for Microsoft Tools (OCMT) |
Oracle Client for Microsoft Tools (OCMT) is a graphical user interface (GUI) native Microsoft Software installer (MSI) that simplifies ODP.NET setup and provides Autonomous Database connectivity to multiple Microsoft data tools. See Connect Power BI and Microsoft Data Tools to Autonomous Database for more information. |
|
Long-Term Backups |
You can create long-term backups on Autonomous Database with a retention period between three months and up to ten years. When you create a long-term backup you can create a one-time backup or set a schedule to automatically create backups that are taken weekly, monthly, quarterly, or annually (yearly). See About Backup and Recovery on Autonomous Database and Create Long-Term Backups on Autonomous Database for more information. |
|
Use Directories to Load Data with |
As an alternative to an object store location URI,
you can specify a directory with See Load Data from Directories in Autonomous Database for more information. |
Parent topic: 2023 What's New
January 2023
| Feature | Description |
|---|---|
| ECPU Compute Model |
Autonomous 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 Database includes built-in tools that you can enable and disable when you provision or clone a database, or at any time for an existing database. See Managing Autonomous Database Built-in Tools for more information. |
|
Configure a Custom Private IP Address for a Private Endpoint |
You can configure a private endpoint when you provision or clone an Autonomous Database instance, or if your instance is configured to use a public endpoint you can change the configuration to use a private endpoint. Optionally when you configure a private endpoint you can enter a custom private IP address. Providing a custom IP address allows you to preserve an existing private IP address when you migrate from another system. See Configure Private Endpoints for more information. |
|
Cross-Region Clone from Backup |
Autonomous Database provides the option to create a clone in another region when you are cloning a database and you select Clone from a backup. In this case, you choose your preferred region to select the region where you want to create the clone. See Clone an Autonomous Database from a Backup for more information. |
|
Send Slack Notifications |
You can send slack notifications from Autonomous Database. This allows you to send messages to a Slack channel or send the results of a query to a Slack channel. See Send Slack Notifications from Autonomous Database for more information. |
Parent topic: 2023 What's New
February 2023
| Feature | Description |
|---|---|
|
Maximum Storage Space Metric |
The See Autonomous Database Metrics and Dimensions for more information. |
|
Oracle Cloud Infrastructure Vault Secret for ADMIN Password |
When you create or clone an Autonomous Database instance or when you reset the ADMIN password, you can use an Oracle Cloud Infrastructure vault secret to specify the ADMIN password. See Use Oracle Cloud Infrastructure Vault Secret for ADMIN Password for more information. |
|
Inactive Connections Detected Event |
The See About Information Events on Autonomous Database for more information. |
|
Enable Automatic Time Zone File Updates |
Autonomous Database lets you choose to enable the feature that automatically updates time zone files on your Autonomous Database instance. See Manage Time Zone File Version on Autonomous Database for more information. |
|
Database Relocate and Failed Logon Events |
The The See About Critical Events on Autonomous Database for more information. |
Parent topic: 2023 What's New
2022 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless in the year 2022.
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
Parent topic: Previous Feature Announcements
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 |
You can use credential objects to set authentication
for use with 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 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. |
Parent topic: 2022 What's New
November 2022
| Feature | Description |
|---|---|
|
Cloud Code Repository Branch Management and Schema Export and Install |
Additions and improvements for Cloud Code Repository in the
See Using and Managing a Cloud Code Repository with Autonomous Database for more information. |
Log File Prefix and Retention Format Options for
COPY_DATA |
See DBMS_CLOUD Package Format Options for more information. |
|
Cross-Region Autonomous Data Guard: Remove Second Hostname from Database Connection Strings |
The 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 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 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 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 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 See Bulk Operations for Files in the Cloud for more information. |
Parent topic: 2022 What's New
October 2022
| Feature | Description |
|---|---|
|
Clone from Backup Select Latest Available Timestamp Option |
When you clone an Autonomous 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 Database instance. See Use Google Service Account to Access Google Cloud Platform Resources for more information. |
|
|
Depending on the value of See SYSDATE_AT_DBTIMEZONE for more information. |
|
View Oracle Cloud Operations Actions |
The See View Oracle Cloud Infrastructure Operations Actions for more information. |
Parent topic: 2022 What's New
September 2022
| Feature | Description |
|---|---|
|
Expanded list of Databases with Oracle-Managed Heterogeneous Connectivity |
Autonomous 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 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 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 Database. See Using OraMTS Recovery Feature on Autonomous Database for more information. |
Parent topic: 2022 What's New
August 2022
| Feature | Description |
|---|---|
|
Documentation Addition: Updated Python Connection Information |
You can connect Python applications to your Autonomous 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 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 Database.
Use Oracle Machine Learning for R to:
See About Oracle Machine Learning for R for more information. |
|
Synchronization with Data Catalog Enhancements |
Use the See DBMS_DCAT SYNC_LOG View for more information. |
|
Regional Availability Metrics |
You can view regional availability metrics by data center for Oracle Autonomous Database. See Monitor Regional Availability of Autonomous Databases for more information. |
Parent topic: 2022 What's New
July 2022
| Feature | Description |
|---|---|
|
Use Oracle Java |
Autonomous 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 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 Database allows you to rotate wallets for an Autonomous 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 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 Database instance. This enables you to compare workloads between an on-premises database or other cloud service database and an Autonomous 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
See EXPORT_DATA Procedure and DBMS_CLOUD Package Format Options for EXPORT_DATA with Text Files (CSV, JSON, and XML for more information. |
Parent topic: 2022 What's New
June 2022
| Feature | Description |
|---|---|
|
Character Set Support |
The Autonomous 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 Database supports using Oracle LogMiner. See Oracle LogMiner for more information. |
| Synchronization with Data Catalog Enhancements |
Synchronize Data Catalog partitioned metadata with Autonomous 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 Database to authenticate and authorize Microsoft Active Directory users. The configuration steps are simplified for enabling Autonomous Database with Centrally Managed Users (CMU). See Use Microsoft Active Directory with Autonomous Database for more information. |
Parent topic: 2022 What's New
May 2022
| Feature | Description |
|---|---|
|
Azure Active Directory (Azure AD ) Integration |
Azure Active Directory (Azure AD ) users can connect to an Autonomous 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 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 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 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 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. |
Parent topic: 2022 What's New
April 2022
| Feature | Description |
|---|---|
|
Display Autonomous Database Availability |
You can monitor Autonomous 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 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 Database to Oracle Databases on a Private Endpoint without a Wallet |
You can create database links from an Autonomous 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 Database. See Availability Service Level Objectives (SLOs) for more information. |
|
Synchronization with Data Catalog Enhancements |
The 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. |
Parent topic: 2022 What's New
March 2022
| Feature | Description |
|---|---|
|
Oracle APEX 21.2 |
Autonomous 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 Database from a standalone Python engine on Linux to connect to Autonomous Database as well as 19c and newer Oracle Database releases. This supports working with OML4Py on Autonomous Database, local third-party IDEs, and other notebook environments, like JupyterLab. It further allows switching between on-premises and Autonomous 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 See About Events Based Notification and Automation on Autonomous Database for more information. |
|
Database Links with Oracle-Managed Heterogeneous Connectivity |
Autonomous 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 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
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 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 Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous 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 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 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. |
Parent topic: 2022 What's New
February 2022
| Feature | Description |
|---|---|
|
Track Oracle Cloud Infrastructure Resources, Cost and Usage |
Autonomous 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 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
|
The initialization parameter
See SYSDATE_AT_DBTIMEZONE for more information. |
Parent topic: 2022 What's New
January 2022
| Feature | Description |
|---|---|
|
Use a Cloud Code Repository |
Autonomous 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 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 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 |
Use GitHub Raw URLs with See GitHub Raw URL Format for more information. |
|
View Maintenance Status and Timezone Version Notifications |
The 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. |
Parent topic: 2022 What's New
2021 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2021.
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- May 2021
- April 2021
- March 2021
- February 2021
- January 2021
Parent topic: Previous Feature Announcements
December 2021
| Feature | Description |
|---|---|
|
Oracle Database API for MongoDB |
Oracle Database API for MongoDB lets applications interact with collections of JSON documents in Autonomous Database using MongoDB commands. See Using Oracle Database API for MongoDB for more information. |
|
Oracle Data Miner Access to Autonomous Database |
Oracle Data Miner in SQL Developer can be used with Oracle Autonomous 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. |
|
|
The |
|
Cross-Region Cloning |
When you clone an Autonomous 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 Database to use Oracle Cloud Infrastructure Identity and Access Management (IAM) authentication and authorization to allow IAM users to access an Autonomous 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 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 See CS_SESSION Package for more information. |
|
Export Data as CSV, JSON, or XML Data Files |
You can export data from Autonomous 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 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. |
Parent topic: 2021 What's New
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 Database or a fleet of Autonomous 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. |
Parent topic: 2021 What's New
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 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 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 Database uses Oracle APEX Release 21.1. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
Parent topic: 2021 What's New
September 2021
| Feature | Description |
|---|---|
|
TLS and Mutual TLS Connections |
Autonomous Database by default supports Mutual TLS (mTLS) connections. You have the option to configure an Autonomous Database instance to support both mTLS and TLS connections. See the following for more information: |
|
Vanity URLs for APEX, ORDSand 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 Database. See the following for additional details, including prerequisites and step-by-step instructions: |
Parent topic: 2021 What's New
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 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 This export method supports all the Cloud Object Stores supported by Autonomous 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 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 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. |
Parent topic: 2021 What's New
July 2021
| Feature | Description |
|---|---|
|
View Patch Details |
You can view Autonomous 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 See Wallet README File for more information. |
Parent topic: 2021 What's New
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 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 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 Database provides two options for Transparent Data Encryption (TDE) to encrypt data in the database:
See Managing Encryption Keys on Autonomous Database for more information. |
|
Autonomous Database RMAN Recovery Catalog |
You can use Autonomous 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 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: |
The See CS_RESOURCE_MANAGER Package for more information. |
Parent topic: 2021 What's New
May 2021
| Feature | Description |
|---|---|
|
Transparent Application Continuity (TAC) on Autonomous Database |
Autonomous 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 Database. When you use ARN role based authentication with Autonomous 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 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 Database. See Using Oracle Graph with Autonomous Database for more information. |
Parent topic: 2021 What's New
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
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 JSON Database |
You have the option to create a limited number of Always Free Autonomous JSON Databases that do not consume cloud credits. Always Free Autonomous 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
See Download Client Credentials (Wallets) for more information. |
|
Documentation Addition: Oracle Graph |
Oracle Graph with Autonomous 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 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. |
Parent topic: 2021 What's New
March 2021
| Feature | Description |
|---|---|
|
Autonomous Database Tools for Database Actions |
Autonomous Database provides the following data tools:
|
|
Maintenance History |
You can view Autonomous 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 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 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. |
Parent topic: 2021 What's New
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 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 Database using SQL. See Query Big Data Service Hadoop (HDFS) Data from Autonomous Database for more information. |
Parent topic: 2021 What's New
January 2021
| Feature | Description |
|---|---|
|
Autonomous Database Events |
Autonomous Database generates events that you can subscribe to
with Oracle Cloud Infrastructure Events. There are two new Information events:
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. |
Parent topic: 2021 What's New
2020 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2020.
- December 2020
- November 2020
- October 2020
- September 2020
- August 2020
- July 2020
- June 2020
- May 2020
- April 2020
- March 2020
- February 2020
- January 2020
Parent topic: Previous Feature Announcements
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 Database |
Oracle Database 21c is available with Always Free Autonomous Database. See the following for more information: |
|
Oracle APEX 20.2 |
Autonomous Database uses Oracle APEX 20.2. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
Parent topic: 2020 What's New
November 2020
| Feature | Description |
|---|---|
|
Amazon S3 Presigned URLs |
You can use a presigned URL in any
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
See Azure Blob Storage URI Format for more information. |
Parent topic: 2020 What's New
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 Database Events |
Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. Subscribing to Autonomous Database events allows you to create automation and to receive notifications when the events occur. See Use Autonomous Database Events for more information. |
Parent topic: 2020 What's New
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 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. |
Parent topic: 2020 What's New
August 2020
| Feature | Description |
|---|---|
|
Autonomous JSON Database |
If your database version is Oracle Database 19c or higher, you can provision an Autonomous JSON Database. Autonomous 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 JSON Database for more information. |
|
Amazon S3-Compatible Object Stores |
Autonomous 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
|
The See SEND_REQUEST Function for more information. |
|
Rename Database |
If your database version is Oracle Database 19c or higher, you can rename your Autonomous Database. See Rename Autonomous Database for more information. |
Parent topic: 2020 What's New
July 2020
| Feature | Description |
|---|---|
|
Oracle APEX Release 20.1 |
Autonomous Database supports Oracle APEX Release 20.1. See Creating Applications with Oracle Application Express in Autonomous Database for more information. If your Autonomous 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 Database provides the Autonomous Data Guard feature to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous 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 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 Database network access is configured to use a private endpoint you can change the configuration to use a public endpoint. Likewise, if your Autonomous Database instance is configured to use a public endpoint, you can change the configuration to use a private endpoint. Autonomous 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 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. |
Parent topic: 2020 What's New
June 2020
| Feature | Description |
|---|---|
|
ORC Format and Complex Types |
Autonomous 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. |
|
|
The 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 Database. See About Customer Managed Oracle REST Data Services on Autonomous Database for more information. |
Parent topic: 2020 What's New
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 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 Database to Oracle Database 19c |
If your Autonomous Database instance is on Oracle Database 18c, you can upgrade to Oracle Database 19c by clicking Upgrade to 19c. |
Parent topic: 2020 What's New
April 2020
| Feature | Description |
|---|---|
| SODA Documents and Collections |
Autonomous 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
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 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 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 Databases in Oracle Cloud directly from the IDE. See Use Oracle Extensions for IDEs to Develop Applications for more information. |
| Per-Second Billing |
Autonomous Database instance CPU and storage usage is billed by the second, with a minimum usage period of 1 minute. Previously Autonomous 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 Database and allows connections to the Autonomous Database instance. The NSG can now be configured with stateful rules. See Configure Private Endpoints with Autonomous Database for more information. |
|
Wallet zip File Contains |
The wallet file that contains client credentials
(wallet files) for your Autonomous Database instance now also has a
See Download Client Credentials (Wallets) for more information. |
Parent topic: 2020 What's New
March 2020
| Feature | Description |
|---|---|
|
Restart Autonomous Database instance |
Use Restart to restart an Autonomous Database instance. See Restart Autonomous 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 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 Database to Oracle Database 19c |
Provides information on upgrading to Oracle Database 19c if your Autonomous Database instance is on Oracle Database 18c. |
|
Oracle Database Versions by Region |
Depending on the region where you provision or clone your database, Autonomous Database supports one or more Oracle Database versions. Oracle Database 19c is available in all commercial regions. |
|
Oracle Application Express Release 19.2 |
Autonomous Database supports Oracle Application Express Release 19.2. See Creating Applications with Oracle Application Express in Autonomous Database for more information. |
Parent topic: 2020 What's New
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 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 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. |
Parent topic: 2020 What's New
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 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 Database by region. See Oracle Database Version Availability by Region for more information. |
DBMS_CLOUD REST API functions
|
The 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
See Sending Mail with Email Delivery on Autonomous Database for more information. |
|
Use ACLs to control access for Autonomous 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. |
Parent topic: 2020 What's New
2019 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2019.
- December 2019
- November 2019
- October 2019
- September 2019
- August 2019
- July 2019
- June 2019
- May 2019
- April 2019
- March 2019
- February 2019
- January 2019
Parent topic: Previous Feature Announcements
December 2019
| Feature | Description |
|---|---|
Support for UTL_HTTP and
UTL_SMTP PL/SQL Packages with
restrictions
|
Autonomous Database supports the Oracle Database PL/SQL packages
See Restrictions for Database PL/SQL Packages for more information. |
| Microsoft Active Directory Users |
You can configure Autonomous 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 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 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. |
Parent topic: 2019 What's New
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 Database. |
| SQL Developer Web Data Loading |
In SQL Developer Web in the Worksheet page, you can upload data from local files into an existing table. |
| 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. |
| View Maintenance Schedule from Oracle Cloud Infrastructure Console | The Autonomous Database Information tab shows the schedule for upcoming
maintenance.
See About Autonomous 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. |
Parent topic: 2019 What's New
October 2019
| Feature | Description |
|---|---|
| Preview Version for Autonomous Database |
Oracle periodically provides a preview version of Autonomous Database that allows you to test your applications and to become familiar with features in the next release of Autonomous 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 See Query External Partitioned Data for more information. |
| Numeric Formats |
With the See DBMS_CLOUD Package Format Options for more information. |
Parent topic: 2019 What's New
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
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 Database. Work requests allow you to track the progress and steps completed in a database operation. See About Work Requests for more information. |
Parent topic: 2019 What's New
August 2019
| Feature | Description |
|---|---|
| Create Directory and Drop Directory commands |
The See Creating and Managing Directories for more information. |
Parent topic: 2019 What's New
July 2019
| Feature | Description |
|---|---|
| Performance Hub |
Oracle Cloud Infrastructure console includes Performance Hub for Autonomous Database. You can view real-time and historical performance data from the Performance Hub. See Monitor Autonomous Database with Performance Hub for more information. |
| Oracle Cloud Infrastructure Native Object Store Authentication |
Autonomous 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. |
Parent topic: 2019 What's New
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 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 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. |
| Azure object store with Data Pump |
Autonomous Database now supports Microsoft Azure cloud storage with Oracle Data Pump. See Import Data Using Oracle Data Pump on Autonomous Database for more information. |
Parent topic: 2019 What's New
May 2019
| Feature | Description |
|---|---|
|
Support for creating database links |
You can create database links with 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
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 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 Database database. See Restrictions for Oracle XML DB for more information. |
| Oracle Management Cloud support |
Oracle Management Cloud allows you to monitor your Autonomous Database database availability and performance. See Using Oracle Database Management for Autonomous Databases for more information. |
|
Modify CPU/IO Shares from Service Console |
Autonomous 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. |
Parent topic: 2019 What's New
April 2019
| Feature | Description |
|---|---|
|
Support for Network Access Control Lists |
Autonomous Database now supports setting a network Access Control List (ACL) to restrict access to a specific Autonomous 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 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 |
Now, when reading a file, by default
See DBMS_CLOUD Package Format Options for more information. |
|
Modify CPU/IO Shares |
Autonomous 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. |
Parent topic: 2019 What's New
March 2019
| Feature | Description |
|---|---|
| Clone Your Database |
Autonomous Database provides cloning where you can choose to clone either the full database or only the database metadata. See Cloning a Database with Autonomous 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 Data Warehouse and Autonomous 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 Database. See Workload Types for more information. |
|
Service Gateway |
You can now set up a Service Gateway with Autonomous Database. A service gateway allows connectivity to Autonomous 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 See DELETE_ALL_OPERATIONS Procedure for more information. |
Parent topic: 2019 What's New
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 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. |
Parent topic: 2019 What's New
January 2019
| Feature | Description |
|---|---|
|
Access Parquet files in Object Stores |
Autonomous 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. |
Parent topic: 2019 What's New
2018 What's New
Announcements for the noteworthy changes made to Oracle Autonomous Database Serverless Deployment in the year 2018.
Parent topic: Previous Feature Announcements
October 2018
| Feature | Description |
|---|---|
|
Oracle Cloud Infrastructure Console changes |
The Autonomous Database console has a new layout and provides new buttons that improve the usability of Autonomous Database. These changes include a new DB Connection button that makes it easier to download client credentials. |
Parent topic: 2018 What's New
September 2018
| Feature | Description |
|---|---|
|
Table compression methods |
In addition to Hybrid Columnar Compression all table compression types are now available in Autonomous 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. |
Parent topic: 2018 What's New
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 Database. |
Parent topic: 2018 What's New
July 2018
| Feature | Description |
|---|---|
|
SQL Developer 18.2.0 and later without Keystore Password field for connections |
When you connect to Autonomous 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. |
Parent topic: 2018 What's New
June 2018
| Feature | Description |
|---|---|
|
New management interfaces |
Autonomous Database is now provisioned and managed using the native Oracle Cloud Infrastructure. This provides a more intuitive user interface to make managing your Autonomous 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 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 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 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 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. |
Parent topic: 2018 What's New
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. |
Parent topic: 2018 What's New
April 2018
| Feature | Description |
|---|---|
|
Microsoft Azure Blob Storage integration |
Autonomous Database now supports Microsoft Azure Blob 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 Database, see LIST_FILES Function. You can also remove files from the local file system. See DELETE_FILE Procedure. |
Parent topic: 2018 What's New