Certify Applications for Compatibility Between Autonomous Database Serverless and Dedicated

Considering that your application is already certified to use Autonomous Database Serverless, the following table helps you evaluate if your application can be certified to use Autonomous Database on Dedicated Exadata Infrastructure too.

The table below lists the options and features that are either:
  • Currently available only in Autonomous Database Serverless, or
  • Has differences in functionality with Autonomous Database on Dedicated Exadata Infrastructure deployments both in Public Cloud and Cloud@Customer.

Note:

There are also features only supported in Autonomous Database on Dedicated Exadata Infrastructure deployment and not supported in Autonomous Database Serverless deployments. However, as the presumption is that you are evaluating to certify your application on both the deployments, starting with Autonomous Database Serverless deployments, we are not discussing them here.

Table - Autonomous Database Serverless Vs Autonomous Database on Dedicated Exadata Infrastructure Features

Feature/Option Autonomous Database Serverless Autonomous Database on Dedicated Exadata Infrastructure
Database In-Memory

Not supported currently.

Supported.

Refer to Database In-Memory for more information.

Database Renaming

Supported.

Not supported currently.
Database Resident Connection Pooling

Use Database Resident Connection Pooling with Autonomous Database Serverless

Not supported currently.
DBMS_AQADM Supported. Supported with the following limitations:
  • DBMS_AQADM.MOVE_QUEUE_TABLE can only be used in ONLINE mode to move Advanced Queuing (AQ) tables from one tablespace to another or within the same tablespace.
  • DBMS_AQADM.MOVE_QUEUE_TABLE can not be used to move AQ tables even in ONLINE mode when table or schema names are case-sensitive and include special identifiers.
DBMS_CLOUD_MACADM

Supported.

Not supported currently.
DBMS_MAX_STRING_SIZE

Supported.

Not supported currently.
Graph Studio

Supported.

Not supported currently.
Modifiable Initialization Parameters

MAX_STRING_SIZE

See List of Initialization Parameters that can be Modified in Autonomous Database Serverless.

For differences with Autonomous Database Serverless, see Modifying Database Initialization Parameters.

Oracle Application Express (APEX) Support

See Restrictions and Limitations for Oracle Application Express with Autonomous Database.

For differences with Autonomous Database Serverless, see Limitations on the Use of Oracle Application Express.

Oracle Cloud Infrastructure PL/SQL SDK API

Supported.

Not supported currently.
Oracle Spatial and Graph
This feature is provided through Oracle Maps Cloud Service.
  • Geocoder
  • Routing Engine
  • Spatial Visualization

See Oracle Spatial Limitations with Autonomous Database Serverless.

For differences with Autonomous Database Serverless, see Limitations on the Use of Oracle Spatial and Graph.

Oracle Machine Learning (OML)
Supports:
  • OML4SQL on all database versions
  • OML4Py
  • OML4R
  • OML Notebooks (SQL, PL/SQL, Python, R, markdown)
  • OML AutoML UI
  • OML Services
  • Oracle Data Miner
For OML product documentation, refer to Oracle Machine Learning on Oracle Help Center.
Supports:
  • OML4SQL on all database versions.
  • Oracle Data Miner
For OML product documentation, refer to Oracle Machine Learning on Oracle Help Center.
Read-only, Restricted Database Modes

Supported.

Not supported currently.
Refreshable Clones

Supported.

Not supported currently.
Time-zone file management

Use the DBMS_CLOUD_ADMIN.ENABLE_FEATURE and DBMS_CLOUD_ADMIN.DISABLE_FEATURE procedures to manage time-zone file updates. See Manage Time Zone File Version on Autonomous Database for more details.

You can choose to include or exclude a time-zone file update along with the automatic quarterly maintenance updates. See Update Autonomous Container Database Maintenance Preferences for detailed instructions.

You can also schedule an on-demand maintenance to update RU (Release Update) along with the time-zone file or just the time-zone file for an ACD. Refer to Schedule a Quarterly Maintenance Update for instructions.

UTL_HTTP

Supported.

Supported. For differences with Autonomous Database Serverless, see Notes on the Use of Database PL/SQL Packages.

UTL_SMTP

Supported.

Supported. For differences with Autonomous Database Serverless, see Notes on the Use of Database PL/SQL Packages.