Certify Applications for Compatibility Between Shared and Dedicated Autonomous Databases

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

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

Note:

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

Table - Shared Vs Dedicated Features

Feature/Option Shared Autonomous Database Deployments Dedicated Autonomous Database Deployments
Modifiable Initialization Parameters

MAX_STRING_SIZE

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

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

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

See Oracle Spatial Limitations with Shared Autonomous Database .

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

Oracle Application Express (APEX) Support

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

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

Database Link Outbound Support

DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK (TCPS only)

Only public IP, public hostname, or using an Oracle Database Gateway is supported. See DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK.

CREATE_DATABASE_LINK (TCP only)

Public and private connections are supported. See the CREATE DATABASE LINK entry in Limitations on the Use of SQL Commands.

Database Resident Connection Pooling

Use Database Resident Connection Pooling with Shared Autonomous Database

Not supported currently.

Fast Ingest

See Notes for Users Migrating from Other Oracle Databases - Fast Ingest.

The following are the differences with Shared Autonomous Database:
  • Tables with column default values (default value columns), encryption, virtual columns, and LOBs can not use fast ingest.
  • Sub-partitioning, INTERVAL, and AUTOLIST partition types are not supported.

See Limitations on the Use of Fast Ingest for more details.

Flashback Transaction

Supported.

Not supported currently.

UTL_HTTP

Supported.

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

UTL_SMTP

Supported.

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

DBMS_CLOUD_ADMIN

Supported.

Not supported currently.

DBMS_CLOUD_MACADM

Supported.

Not supported currently.

DBMS_MAX_STRING_SIZE

Supported.

Not supported currently.

Database Renaming

Supported.

Not supported currently.

Oracle Cloud Infrastructure PL/SQL SDK API

Supported.

Not supported currently.

Read-only, Restricted Database Modes

Supported.

Not supported currently.

Refreshable Clones

Supported.

Not supported currently.

OML Notebook

Supported.

Not supported currently.

Graph Studio

Supported.

Not supported currently.