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

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 for Natural Language Interaction with your Database for more information.

Break Glass Access with SAAS_ADMIN User

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.

Vault Secret Credential Objects

You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required). Supported vaults are:

• Oracle Cloud Infrastructure Vault
• Azure Key Vault
• AWS Secrets Manager
• GCP Secret Manager

See Use Vault Secret Credentials for more information.

Documentation Addition: Billing Information

Documentation includes summary and detailed Autonomous 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.

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 for Natural Language Interaction with your Database for more information.

Cloud Links Usability and Security

Cloud Links provide a cloud-based method to collaborate between Autonomous 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.

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.

Free Container Image

Use the 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 Autonomous Database Free Container Image for more information.

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 an Autonomous Database Instance 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.

DBMS_SHARE Package

You can use the subprograms and views in the DBMS_SHARE package to share data with external systems.

See DBMS_SHARE Package for more information.

Logical Partition Change Tracking (LPCT)

Logical Partition Change Tracking enables you to create logical partitions on base tables. It evaluates the staleness of the base tables for individual logical partitions without using a materialized view log or requiring any of the tables used in the materialized view to be partitioned.

Logical Partition Change Tracking provides the capability to leverage the user-supplied logical partitioning information of base tables of materialized view for a more fine-grained, partition-level tracking of stale data for both refresh and rewrite purposes. While classical Partitioning Change Tracking (PCT) relies on the physical partitioning of tables, LPCT has no dependency on tables being physically partitioned; you can use LPCT with both partitioned and nonpartitioned tables.

See Logical Partition Change Tracking and Materialized Views for more information.

Update OCPU to ECPU Compute Model

You can update an Autonomous 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.

Track Table Changes with Flashback Time Travel

Use Flashback Time Travel to view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

See Tracking Table Changes with Flashback Time Travel for more information.

Database Actions Quick Links

Database Actions on the Oracle Cloud Infrastructure Console provides quick links to select Database Actions cards or to select the Database Actions Launchpad.

See Access Database Actions as ADMIN for more information.

Object Storage and REST Endpoint Management

DBMS_CLOUD supports a number of preconfigured Object Store and REST endpoints. DBMS_CLOUD also allows you to access additional customer-managed endpoints.

See DBMS_CLOUD Endpoint Management for more information.

detectfieldorder DBMS_CLOUD Format Option

The detectfieldorder format option specifies that the fields in external data files are in a different order than the columns in the table. Specify this option with DBMS_CLOUD.COPY_DATA, DBMS_CLOUD.CREATE_EXTERNAL_TABLE, DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE, or DBMS_CLOUD.CREATE_HYBRID_PART_TABLE to detect the order of fields using the first row of each external data file and map it to the columns of the table.

See DBMS_CLOUD Package Format Options for more information.

Vault Secret Credential Objects

You can create vault secret credentials with secrets stored in Oracle Cloud Infrastructure Vault. You can use vault secret credentials to access cloud resources or to access other databases (use vault secret credentials anywhere where username/password type credentials are required).

See Use Vault Secret Credentials for more information.

Export to Directory with DBMS_CLOUD.EXPORT_DATA

Export files as text or as Oracle Data Pump dump files to a directory.

See Export Data to a Directory for more information.

Oracle Cloud Infrastructure Signing Key Based Authentication for Oracle Data Pump Import

Oracle Data Pump import using impdp supports credentials created using Oracle Cloud Infrastructure key based attributes.

See Import Data Using Oracle Data Pump on Autonomous Database for more information.

Configurable Automatic Failover Data Loss Limit for a Local Standby Database

For Autonomous Data Guard you can specify an automatic failover data loss limit between 0 and 3600 seconds. Autonomous Data Guard performs automatic failover to a local standby database when a local standby database is available and the system can guarantee either the default zero data loss RPO or up to the data loss limit you specify.

See Automatic Failover with a Standby Database for more information.

Oracle Workspace Manager

Oracle Workspace Manager provides an infrastructure that enables applications to create workspaces and group different versions of table row values in different workspaces. Use Oracle Workspace Manager to version-enable one or more user tables in the database.

See Using Oracle Workspace Manager on Autonomous Database for more information.

Automatic Failover Begin and Automatic Failover End Events

The AutonomousDatabase-AutomaticFailoverBegin and AutonomousDatabase-AutomaticFailoverEnd events are generated when an automatic failover begins and ends. These events are only be triggered if you are using Autonomous Data Guard.

See About Critical Events on Autonomous Database for more information.

Operator Access Event

The OperatorAccess event is generated when operator access is detected for the database.

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

There are now two options for configuring Autonomous Database with Centrally Managed Users (CMU) with Microsoft Active Directory:

• Active Directory (AD) servers publicly accessible: the Active Directory servers are accessible from Autonomous Database through the public internet.

• Active Directory (AD) servers reside on a private endpoint: the Active Directory servers reside on a private endpoint and are not accessible from Autonomous Database through the public internet.

See Use Microsoft Active Directory with Autonomous Database for more information.

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 DBMS_CLOUD

DBMS_CLOUD provides format parameter options for logging customization: enablelogs, logprefix, logdir, and logretention.

See DBMS_CLOUD Package Format Options for more information.

RESULT_CACHE_MODE Parameter is Modifiable at Session and System Level

Set the RESULT_CACHE_MODE parameter to specify which queries are eligible to store result sets in the result cache. Only query execution plans with the result cache operator will attempt to read from or write to the result cache.

See RESULT_CACHE_MODE for more information.

Stripe Financial Views

Stripe is an online payment processing and credit card processing platform for businesses. The Stripe views allow you to query views created on top of Stripe APIs with DBMS_CLOUD to get Stripe information such as products, invoices, plans, accounts, subscriptions, and customers.

See Stripe Views on Autonomous Database for more information.

Oracle GoldenGate Parallel Replicat (Integrated Mode)

Integrated Parallel Replicat (iPR) supports GoldenGate replication apply for procedural replication, Automatic CDR, and DML handlers.

See Deciding Which Apply Method to Use and About Parallel Replicat for more information.

Persistent Messaging in DBMS_PIPE

The DBMS_PIPE package has extended functionality on Autonomous Database to support persistent messaging, where messages are stored in Cloud Object Store.

See Use Persistent Messaging with Messages Stored in Cloud Object Store for more information.

Access Oracle Cloud Infrastructure Logging Data with Autonomous 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.

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 is an addition to the DBMS_PIPE package that allows you to cache a custom message. Using a Singleton Pipe you can send and retrieve a custom message and share the message across multiple database sessions with concurrent reads.

See Caching Messages with Singleton Pipes for more information.

Migrate Databases Across Regions with Minimal Downtime Using Autonomous Data Guard

You may now terminate, as well as perform all other Primary database actions on a remote Autonomous Data Guard standby when it becomes the Primary database, after a switchover or after a failover. This enables you to use a remote peer for migrating your database to the remote region.

See Using Standby Databases with Autonomous Data Guard for Disaster Recovery for more information.

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.

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.

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 DBMS_CLOUD.EXPORT_DATA to export data as text. The text format export options are CSV, JSON, Parquet, or XML.

See Export Data to Object Store as Text (CSV, JSON, Parquet, or XML) for more information.

Oracle Real Application Testing Capture and Replay

Use Capture and Replay from one Autonomous 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 DBMS_CLOUD Procedures

As an alternative to an object store location URI, you can specify a directory with DBMS_CLOUD procedures to load or unload data from files in a directory, including directories created on attached network file systems.

See Load Data from Directories in Autonomous Database for more information.

Maximum Storage Space Metric

The StorageMax metric shows the maximum amount of storage reserved for the database.

See Autonomous Database Metrics and Dimensions for more information.

Oracle Cloud Infrastructure Vault Secret for ADMIN Password

When you create or clone an Autonomous Database instance or when you reset the ADMIN password, you can use an Oracle Cloud Infrastructure vault secret to specify the ADMIN password.

See Use Oracle Cloud Infrastructure Vault Secret for ADMIN Password for more information.

Inactive Connections Detected Event

The InactiveConnectionsDetected event is generated when the number of inactive database connections detected is above a certain ratio, compared to all database connections for the Autonomous Database instance. Subscribing to this event can help you keep track of unused connections.

See About Information Events on Autonomous Database for more information.

Enable Automatic Time Zone File Updates

Autonomous 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 FailedLoginWarning event is generated when the number of failed login attempts reaches 3 * number of total users in the last three (3) hours.

The InstanceRelocateBegin and InstanceRelocateEnd events are triggered when an Autonomous Database instance is relocated to another Exadata infrastructure due to server maintenance, hardware refresh, a hardware issue, or as part of a resource scale up.

See About Critical Events on Autonomous Database for more information.

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.

Data Pipelines for Loading and Exporting

Data pipelines allow you to repeatedly load data from object store, or export data to object store.

Load pipelines provide continuous incremental data loading from external sources (as data arrives on object store it is loaded to a database table). Export pipelines provide continuous incremental data exporting to object store (as new data appears in a database table it is exported to object store).

See Using Data Pipelines for Continuous Load and Export for more information.

Credential Objects for use with UTL_HTTP, UTL_SMTP, and DBMS_LDAP

You can use credential objects to set authentication for use with UTL_HTTP, UTL_SMTP or DBMS_LDAP.

See Use Credential Objects to set SMTP Authentication, Use Credential Objects to Set HTTP Authentication, and PL/SQL Packages for more information.

Medium and High Service Limits with Auto Scaling

The number of concurrent statements for the high and medium services increases by three times when OCPU Auto Scaling is enabled.

See Service Concurrency for more information.

Multiple Data Catalog Support

Instead of each Autonomous 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.

Cloud Code Repository Branch Management and Schema Export and Install

Additions and improvements for Cloud Code Repository in the DBMS_CLOUD_REPO package for (Git) repository branch management and schema export and install.

See Using and Managing a Cloud Code Repository with Autonomous Database for more information.

DBMS_CLOUD.COPY_DATA supports the format parameter options: logretention and logprefix.

See DBMS_CLOUD Package Format Options for more information.

Cross-Region Autonomous Data Guard: Remove Second Hostname from Database Connection Strings

The wallet.zip and the connection strings provided for a database with cross-region Autonomous Data Guard enabled no longer contain both the primary and standby database hostnames in a single connection string or wallet.

To avoid connection retry delays and optimize your disaster recovery setup, it is recommended to use the Primary database wallet or connection string to connect to the Primary database, and the remote database wallet or connection string to connect to the remote database (when the remote database is Available to connect to, after a switchover or failover).

See Cross-Region Autonomous Data Guard Connection Strings and Wallets for more information.

Data Transforms in Database Actions

Data Transforms is a built-in data integration tool and is accessible from Database Actions. Data Transforms is a simple-to-use, drag-and-drop, no-code tool to load and transform data from heterogeneous sources to Autonomous 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 DBMS_CLOUD offers parallel execution support for bulk file upload, download, copy, and transfer activities, which streamlines the user experience and delivers optimal performance for bulk file operations.

See Bulk Operations for Files in the Cloud for more information.

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.

SYSDATE_AT_DBTIMEZONE Parameter is Modifiable at Session and System Level

Depending on the value of SYSDATE_AT_DBTIMEZONE, you see either the date and time based on the default Autonomous Database time zone, Coordinated Universal Time ‎(UTC)‎, or based on the time zone that you set in your database.

See SYSDATE_AT_DBTIMEZONE for more information.

View Oracle Cloud Operations Actions

The DBA_OPERATOR_ACCESS view stores information on the actions that Oracle Cloud Infrastructure cloud operations performs on your Autonomous Database. This view will not show results if Oracle Cloud Infrastructure cloud operations hasn't performed any actions or run any statements in your Autonomous Database instance.

See View Oracle Cloud Infrastructure Operations Actions for more information.

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 APEXUpgradeBegin and APEXUpgradeEnd events are generated when you are using Oracle APEX and your Autonomous Database instance begins an upgrade or completes an upgrade to a new Oracle APEX release.

See About Events Based Notification and Automation on Autonomous Database for more information.

Oracle MTS (OraMTS) Recovery Service

Use Oracle MTS (OraMTS) Recovery Service to resolve in-doubt Microsoft Transaction Server transactions on Autonomous Database.

See Using OraMTS Recovery Feature on Autonomous Database for more information.

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)

Use Oracle Machine Learning for R to:

• Perform data exploration and data preparation while seamlessly leveraging Oracle Database as a high-performance computing environment.
• Run user-defined R functions on database spawned and controlled R engines, with system-supported data-parallel and task-parallel capabilities.
• Access and use powerful in-database machine learning algorithms from R language.

See About Oracle Machine Learning for R for more information.

Synchronization with Data Catalog Enhancements

Use the DBMS_DCAT$SYNC_LOG view to easily access the log for the latest Data Catalog synchronization execution.

See DBMS_DCAT SYNC_LOG View for more information.

Regional Availability Metrics

You can view regional availability metrics by data center for Oracle Autonomous Database.

See Monitor Regional Availability of Autonomous Databases for more information.

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.

You can optionally write column names as the first line in output files when you use the EXPORT_DATA procedure with CSV output.

See EXPORT_DATA Procedure and DBMS_CLOUD Package Format Options for EXPORT_DATA with Text Files (CSV, JSON, and XML for more information.

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.

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.

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 supports operation from Terraform scripts

See the following for more information:

• Use the API

• oci_database_autonomous_database

• Oracle Cloud Infrastructure Provider

• Terraform Registry Data Source: Data Source: oci_database_autonomous_database

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.

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 DBMS_DCAT RUN_SYNC procedure has new parameters to give you more control over what objects are synchronized and how the synchronization is performed.

See CREATE_SYNC_JOB Procedure and RUN_SYNC Procedure for more information.

Data Catalog Views

Discover all accessible data catalogs in the current region or across all regions.

See ALL_DCAT_GLOBAL_ACCESSIBLE_CATALOGS View and ALL_DCAT_LOCAL_ACCESSIBLE_CATALOGS View for more information.

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 APEXUpgradeAvailable event is generated when you are using Oracle APEX and a new release becomes available.

See About Events Based Notification and Automation on Autonomous Database for more information.

Database Links with Oracle-Managed Heterogeneous Connectivity

Autonomous 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 file$name and file$path to find the source file name and the Object Store path URL for that file.

See External Table Metadata Columns for more information.

External Tables with Partitioning Specified in Source Files

When you use external file partitioning with the partitions specified in external source files, Autonomous 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.

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 SYSDATE and SYSTIMESTAMP

The initialization parameter SYSDATE_AT_DBTIMEZONE parameter enables special handling in a session for the date and time value returned in calls to SYSDATE and SYSTIMESTAMP. Depending on the value of SYSDATE_AT_DBTIMEZONE, you see either the date and time based on the default Autonomous Database time zone, Coordinated Universal Time ‎(UTC)‎, or based on the time zone that you set in your database.

See SYSDATE_AT_DBTIMEZONE for more information.

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.

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 DBMS_CLOUD

Use GitHub Raw URLs with DBMS_CLOUD APIs to access source files that reside on a GitHub Repository.

See GitHub Raw URL Format for more information.

View Maintenance Status and Timezone Version Notifications

The DB_NOTIFICATIONS view stores information about maintenance status notifications and timezone version upgrade notifications for your Autonomous Database instance.

See View Maintenance Status and Timezone Version Notifications for more information.

One-way TLS Connections on Linux x64 Clients using Oracle Call Interface without a Wallet

Using TLS authentication for Oracle Call Interface connections on Linux x64, a wallet is not required when the client program connects with Oracle Instant Client 19.13. Using TLS authentication for Oracle Call Interface connections on all other platforms, or without Oracle Instant Client 19.13, clients must provide a generic CA root certificate wallet.

See Prepare for Oracle Call Interface, ODBC, and JDBC OCI Connections Using TLS Authentication for more information.

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.

DBMS_PIPE PL/SQL Package

The DBMS_PIPE package that lets two or more sessions in the same instance communicate is available in Autonomous Database.

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 CS_SESSION Package to switch the database service and consumer group of an existing session.

See CS_SESSION Package for more information.

Export Data as CSV, JSON, or XML Data Files

You can export data from Autonomous 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.

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.

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.

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:

• About Connecting to an Autonomous Database Instance

• Update Network Options to Allow TLS or Require Only Mutual TLS (mTLS) Authentication on Autonomous Database

Vanity URLs for APEX, ORDS and Database Tools

You can configure a custom domain name or vanity URL for your APEX apps, Oracle REST Data Services (ORDS), and developer tools by placing an Oracle Cloud Infrastructure Load Balancer directly in front of your Autonomous Database.

See the following for additional details, including prerequisites and step-by-step instructions:

• Access Oracle APEX, Oracle REST Data Services, and Developer Tools Using a Vanity URL

• Access Oracle REST Data Services, Oracle APEX, and Developer Tools Using a Vanity URL

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 DBMS_CLOUD.EXPORT_DATA to export data to your Cloud Object Store as JSON, by specifying a query.

This export method supports all the Cloud Object Stores supported by Autonomous 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.

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 README file includes links for Autonomous Database tools and resources, including: Database Actions, Graph Studio, Oracle APEX, Oracle Machine Learning Notebooks, Autonomous Database Service Console, and SODA drivers.

See Wallet README File for more information.

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:

• Oracle-managed encryption keys
• Customer-managed encryption keys

See Managing Encryption Keys on Autonomous Database for more information.

Autonomous Database RMAN Recovery Catalog

You can use Autonomous 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: CS_RESOURCE_MANAGER Package

The CS_RESOURCE_MANAGER package provides procedures to list and update consumer group parameters, and to revert parameters to default values.

See CS_RESOURCE_MANAGER Package for more information.

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.

Change MEDIUM Service Concurrency Limit

If your application requires a customized concurrency limit not available with the predefined services, you can modify the concurrency limit for the MEDIUM service.

See Change MEDIUM Service Concurrency Limit for more information.

DBMS_CLOUD REST API Results Cache

The DBMS_CLOUD REST API functions allow you to make HTTP requests and obtain and save results. Saving results in the cache allows you to view past results with the SESSION_CLOUD_API_RESULTS view. Saving and querying historical results of DBMS_CLOUD REST API requests can help you when you need to work with previous results in your applications.

See DBMS_CLOUD REST API Results Cache for more information.

View and Manage Customer Contacts for Operational Issues and Announcements

When customer contacts are set, Oracle sends notifications to the specified email addresses to inform you of service-related issues. Contacts in the customer contacts list receive unplanned maintenance notices and other notices, including but not limited to notices for database upgrades and upcoming wallet expiration.

See View and Manage Customer Contacts for Operational Issues and Announcements for more information.

Always Free Autonomous 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 WalletExpirationWarning event to be notified when a wallet is due to expire.

See Download Client Credentials (Wallets) for more information.

Documentation Addition: Oracle Graph

Oracle Graph with Autonomous 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.

Autonomous Database Tools for Database Actions

Autonomous Database provides the following data tools:

• Data Load: helps you select data to load from your local computer, from tables in other databases, or from cloud storage. Then you can add the data you select to new or existing tables or views in Autonomous Database.

  See The Data Load Page for more information.

• Catalog: helps you to see information about the entities in your Autonomous Database, and to see the effect that changing an object has on other objects. Catalog provides a tool for you to examine data lineage and understand the impact of changes.

  See The Catalog Page for more information.

• Data Insights: crawls a table or business model and discovers hidden patterns, anomalies, and outliers in your data. Insights are automatically generated by built-in analytic functions. The results of the insight analysis appear as bar charts in the Data Insights dashboard.

  See The Data Insights Page for more information.

• Business Models: describes the business entities that are derived from data in your Autonomous Database schema or from other sources. This allows you to create a semantic model on top of your data identifying hierarchies, measures, and dimensions.

  See The Business Models Page for more information.

Maintenance History

You can view Autonomous Database maintenance history to see details about past maintenance, such as the start time and stop time for past maintenance events.

See About Autonomous Database Maintenance Windows and History for more information.

Oracle Machine Learning AutoML User Interface

AutoML User Interface (AutoML UI) is an Oracle Machine Learning interface that provides you with no-code automated machine learning. When you create and run an experiment in AutoML UI, it automatically performs algorithm and feature selection, as well as model tuning and selection, thereby enhancing productivity as well as model accuracy and performance.

See Get Started with AutoML for more information.

Oracle Machine Learning Models

REST endpoints are available so that you can store Machine Learning models and create scoring endpoints for the models. The REST API for Oracle Machine Learning Services supports both Oracle Machine Learning models and ONNX format models.

See REST API for Oracle Machine Learning Services for more information.

ADMIN Password Expiration Warning Event

The AdminPasswordWarning event produces an event when the Autonomous Database ADMIN password is expiring within 30 days or is expired.

See About Events Based Notification and Automation on Autonomous Database for more information.

Oracle Machine Learning for Python (OML4Py)

Oracle Machine Learning for Python (OML4Py) on Autonomous 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.

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.

Autonomous Database Events

Autonomous Database generates events that you can subscribe to with Oracle Cloud Infrastructure Events. There are two new Information events: ScheduledMaintenanceWarning and WalletExpirationWarning.

See Use Autonomous Database Events for more information.

Private Endpoint Support for Tools (Oracle Machine Learning Notebooks are supported with Private Endpoints)

You can access Oracle APEX, Oracle SQL Developer Web, Oracle REST Data Services, and Oracle Machine Learning Notebooks with Private Endpoints.

See Configuring Network Access with Private Endpoints for more information.

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:

• Always Free Autonomous Database
• Always Free Autonomous Database Oracle Database 21c Features

Oracle APEX 20.2

Autonomous Database uses Oracle APEX 20.2.

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

Amazon S3 Presigned URLs

You can use a presigned URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon Simple Storage Service, without the need to create a credential.

See Amazon S3 Compatible URI Format for more information.

Azure Blob Storage Shared Access Signatures (SAS) URLs

You can use Shared Access Signatures (SAS) URL in any DBMS_CLOUD procedure that takes a URL to access files in Azure Blob Storage, without the need to create a credential.

See Azure Blob Storage URI Format for more information.

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.

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.

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 SEND_REQUEST

The DBMS_CLOUD SEND_REQUEST function supports long running requests with the additional parameters: async_request_url, wait_for_states, and timeout.

See SEND_REQUEST Function for more information.

Rename Database

If your database version is Oracle Database 19c or higher, you can rename your Autonomous Database.

See Rename Autonomous Database for more information.

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.

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.

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.

PUT_OBJECT Maximum File Transfer Size Increase

The DBMS_CLOUD.PUT_OBJECT procedure maximum size limit for file transfers to Oracle Cloud Infrastructure Object Storage is increased to 50 GB.

See PUT_OBJECT Procedure for more information.

Customer Managed Oracle REST Data Services

You can use a customer managed environment to run Oracle REST Data Services (ORDS) if you want to control the configuration and management of ORDS. Installing and configuring a customer managed environment for ORDS allows you to run ORDS with configuration options that are not possible using the default Oracle managed ORDS available with Autonomous Database.

See About Customer Managed Oracle REST Data Services on Autonomous Database for more information.

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.

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.

You can use Oracle Data Pump dump files in the Cloud as source files to load your data. The files for this load type must be exported from the source system using the ORACLE_DATAPUMP access driver in External Tables.

See Create Credentials and Load Data Pump Dump Files into an Existing Table for more information.

You can query Oracle Data Pump dump files in the Cloud by creating an external table. The source files to create this type of external table must be exported from the source system using the ORACLE_DATAPUMP access driver in External Tables.

See Query External Data Pump Dump Files for more information.

Oracle Extensions for IDEs

You can use Oracle extensions for IDEs to develop applications on Autonomous 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.

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 README File

The wallet file that contains client credentials (wallet files) for your Autonomous Database instance now also has a README file with wallet expiration information. Wallet files that were downloaded prior to April 2020 do not contain this file.

See Download Client Credentials (Wallets) for more information.

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.

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.

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.

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.

By default the database uses extended data types and the value of MAX_STRING_SIZE is set to the value EXTENDED. To support migration from older Oracle Databases or applications you can set MAX_STRING_SIZE to the value STANDARD.

See Checking and Setting MAX_STRING_SIZE for more information.

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.

The DBMS_CLOUD REST API functions allow you to make HTTP requests using DBMS_CLOUD.SEND_REQUEST. These functions provide a generic API that lets you call REST APIs from supported cloud services.

See DBMS_CLOUD REST APIs for more information.

The documentation is updated to provide the steps and sample code for sending email using UTL_SMTP.

See Sending Mail with Email Delivery on Autonomous Database for more information.

Use ACLs to control access for Autonomous 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.

Autonomous Database supports the Oracle Database PL/SQL packages UTL_HTTP, UTL_SMTP, and DBMS_NETWORK_ACL_ADMIN with restrictions.

See Restrictions for Database PL/SQL Packages for more information.

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 DBMS_CLOUD.VALIDATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_HYBRID_PART_TABLE.

See Validate External Partitioned Data and Validate Hybrid Partitioned Data for more information.

Use ACL IP address or CIDR block settings to control access for Autonomous 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.

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.

Use ACLs to specify Oracle Cloud Infrastructure VCNs that can connect to your Autonomous Database.

See Use an Access Control List with Autonomous Database for more information.

In SQL Developer Web in the Worksheet page, you can upload data from local files into an existing table.

See Load Data from Local Files with SQL Developer Web for more information.

The Tools Tab provides access to APEX from Oracle Cloud Infrastructure Console.

See Access Oracle Application Express Administration Services for more information.

See Access SQL Developer Web as ADMIN for more information.

See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for more information.

See About Autonomous Database Maintenance Windows for more information.

See LIST_FILES Function and LIST_OBJECTS Function for more information.

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.

You can download database specific instance wallets or regional wallets.

See Download Client Credentials (Wallets) for more information.

You can rotate database specific instance wallets or regional wallets.

See Rotate Wallets for Autonomous Database for more information.

You can create and validate external partitioned tables with the DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE and DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE statements.

See Query External Partitioned Data for more information.

With the numberformat and numericcharacters format options Autonomous Database supports formats to interpret numeric strings correctly.

See DBMS_CLOUD Package Format Options for more information.

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.

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.

If your source files reside on an Object Store that provides public URLs, you can use public URLs with DBMS_CLOUD procedures. Public means the Object Storage service supports anonymous, unauthenticated access to the Object Store files.

See URI Format Using Public URL for more information.

Work Requests 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.

The data_pump_dir directory is available in a database. You can use CREATE DIRECTORY to create additional directories. To drop a directory, you can use the DROP DIRECTORY command.

See Creating and Managing Directories for more information.

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.

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.

You can move a database to a different Oracle Cloud Infrastructure compartment.

See Move an Autonomous Database to a Different Compartment for more information.

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.

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.

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.

Enabling auto scaling allows a database to use up to three times more CPU and IO resources than the currently specified CPU Core Count. When auto scaling is enabled, if your workload requires additional CPU and IO resources the database automatically uses the resources without any manual intervention required.

See Use Auto Scaling for more information.

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.

Support for creating database links

You can create database links with DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to access objects on another database.

See Use Database Links with Autonomous Database for more information.

Oracle Spatial and Graph with limitations

Oracle Text with limitations

See Restrictions for Oracle Text for more information.

Oracle Cloud Infrastructure Native URI Format Supported with Oracle Data Pump

For importing data from Data Pump files using impdp, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can use the Oracle Cloud Infrastructure native URIs in addition to the Swift URIs.

See DBMS_CLOUD Package File URI Formats for more information.

If your source files reside on the Oracle Cloud Infrastructure Object Storage you can use the Oracle Cloud Infrastructure Pre-Authenticated URIs. When you create a pre-authenticated request, a unique URL is generated. You can use a pre-authenticated URL in any DBMS_CLOUD procedure that takes a URL to access files in the Oracle Cloud Infrastructure object store, without the need to create a credential.

See DBMS_CLOUD Package File URI Formats for more information.

Oracle XML DB 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.

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.

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.

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 DBMS_CLOUD

Now, when reading a file, by default DBMS_CLOUD tries to automatically find the correct newline character to use as the record delimiter, either for Windows, newline character "\r\n", or for UNIX/Linux newline character "\n". If DBMS_CLOUD finds one of these it sets the record delimiter for the file. You can specify the record delimiter explicitly if you want to override the default behavior.

See DBMS_CLOUD Package Format Options for more information.

Modify CPU/IO Shares

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

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.

See DBMS_CLOUD Package File URI Formats for more information.

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 DBMS_CLOUD.DELETE_ALL_OPERATIONS is now documented.

See DELETE_ALL_OPERATIONS Procedure for more information.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Microsoft Azure Blob Storage or Azure Data Lake Storage integration

Autonomous Database now supports Microsoft Azure Blob Storage or Azure Data Lake Storage for data loading and querying external data. You can load data from or run queries on files residing on Azure Blob Storage. See Loading Data from Files in the Cloud.

Manage files on the local file system

You can now list files residing on the local file system on Autonomous Database, see LIST_FILES Function.

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