RDS for Oracle releases - Amazon Relational Database Service (original) (raw)

RDS for Oracle for Oracle supports multiple Oracle Database releases.

Topics

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.

Topics

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% ofsga_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):

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.

Topics

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):