RDS for Oracle releases - Amazon Relational Database Service

RDS for Oracle releases

RDS for Oracle for Oracle supports multiple Oracle Database releases.

Note

For information about upgrading your releases, see Upgrading the RDS for Oracle DB engine.

Oracle Database 21c with Amazon RDS

Amazon RDS supports Oracle Database 21c, which includes Oracle Enterprise Edition and Oracle Standard Edition 2. Oracle Database 21c (21.0.0.0) includes many new features and updates from the previous version. A key change is that Oracle Database 21c supports only the multitenant architecture: you can no longer create a database as a traditional non-CDB. To learn more about the differences between CDBs and non-CDBs, see Limitations of RDS for Oracle CDBs.

In this section, you can find the features and changes important to using Oracle Database 21c (21.0.0.0) on Amazon RDS. For a complete list of the changes, see the Oracle database 21c documentation. For a complete list of features supported by each Oracle Database 21c edition, see Permitted features, options, and management packs by Oracle database offering in the Oracle documentation.

Amazon RDS parameter changes for Oracle Database 21c (21.0.0.0)

Oracle Database 21c (21.0.0.0) includes several new parameters and parameters with new ranges and new default values.

New parameters

The following table shows the new Amazon RDS parameters for Oracle Database 21c (21.0.0.0).

Name

Range of values

Default value

Modifiable

Description

blockchain_table_max_no_drop

NONE | 0

NONE

Y

Lets you control the maximum amount of idle time that can be specified when creating a blockchain table.

dbnest_enable

NONE | CDB_RESOURCE_PDB_ALL

NONE

N

Allows you to enable or disable dbNest. DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs.

dbnest_pdb_fs_conf

NONE | pathname

NONE

N

Specifies the dbNest file system configuration file for a PDB.

diagnostics_control

ERROR | WARNING | IGNORE

IGNORE

Y

Allows you to control and monitor the users who perform potentially unsafe database diagnostic operations.

drcp_dedicated_opt

YES | NO

YES

Y

Enables or disables the use of dedicated optimization with Database Resident Connection Pooling (DRCP).

enable_per_pdb_drcp

true | false

true

N

Controls whether Database Resident Connection Pooling (DRCP) configures one connection pool for the entire CDB or one isolated connection pool for each PDB.

inmemory_deep_vectorization

true | false

true

Y

Enables or disables the deep vectorization framework.

mandatory_user_profile

profile_name

N/A

N

Specifies the mandatory user profile for a CDB or PDB.

optimizer_capture_sql_quarantine

true | false

false

Y

Enables or disables the deep vectorization framework.

optimizer_use_sql_quarantine

true | false

false

Y

Enables or disables the automatic creation of SQL Quarantine configurations.

result_cache_execution_threshold

0 to 68719476736

2

Y

Specifies the maximum number of times a PL/SQL function can be executed before its result is stored in the result cache.

result_cache_max_temp_result

0 to 100

5

Y

Specifies the percentage of RESULT_CACHE_MAX_TEMP_SIZE that any single cached query result can consume.

result_cache_max_temp_size

0 to 2199023255552

RESULT_CACHE_SIZE * 10

Y

Specifies the maximum amount of temporary tablespace (in bytes) that can be consumed by the result cache.

sga_min_size

0 to 2199023255552 (maximum value is 50% of sga_target)

0

Y

Indicates a possible minimum value for SGA usage of a pluggable database (PDB).

tablespace_encryption_default_algorithm

GOST256 | SEED128 | ARIA256 | ARIA192 | ARIA128 | 3DES168 | AES256 | AES192 | AES128

AES128

Y

Specifies the default algorithm the database uses when encrypting a tablespace.

Changes for the compatible parameter

The compatible parameter has a new maximum value for Oracle Database 21c (21.0.0.0) on Amazon RDS. The following table shows the new default value.

Parameter name

Oracle Database 21c (21.0.0.0) maximum value

compatible

21.0.0

Removed parameters

The following parameters were removed in Oracle Database 21c (21.0.0.0):

  • remote_os_authent

  • sec_case_sensitive_logon

  • unified_audit_sga_queue_size

Oracle Database 19c with Amazon RDS

Amazon RDS supports Oracle Database 19c, which includes Oracle Enterprise Edition and Oracle Standard Edition Two.

Oracle Database 19c (19.0.0.0) includes many new features and updates from the previous version. In this section, you can find the features and changes important to using Oracle Database 19c (19.0.0.0) on Amazon RDS. For a complete list of the changes, see the Oracle database 19c documentation. For a complete list of features supported by each Oracle Database 19c edition, see Permitted features, options, and management packs by Oracle database offering in the Oracle documentation.

Amazon RDS parameter changes for Oracle Database 19c (19.0.0.0)

Oracle Database 19c (19.0.0.0) includes several new parameters and parameters with new ranges and new default values.

New parameters

The following table shows the new Amazon RDS parameters for Oracle Database 19c (19.0.0.0).

Name

Values

Modifiable

Description

lob_signature_enable

TRUE, FALSE (default)

Y

Enables or disables the LOB locator signature feature.

max_datapump_parallel_per_job

1 to 1024, or AUTO

Y

Specifies the maximum number of parallel processes allowed for each Oracle Data Pump job.

Changes to the compatible parameter

The compatible parameter has a new maximum value for Oracle Database 19c (19.0.0.0) on Amazon RDS. The following table shows the new default value.

Parameter name

Oracle Database 19c (19.0.0.0) maximum value

compatible

19.0.0

Removed parameters

The following parameters were removed in Oracle Database 19c (19.0.0.0):

  • exafusion_enabled

  • max_connections

  • o7_dictionary_access