RDS for Oracle features

Amazon RDS for Oracle supports most of the features and capabilities of Oracle Database. Some features might have limited support or restricted privileges. Some features are only available in Enterprise Edition, and some require additional licenses. For more information about Oracle Database features for specific Oracle Database versions, see the Oracle Database Licensing Information User Manual for the version you're using.

You can filter new Amazon RDS features on the What's New with Database? page. For Products, choose Amazon RDS. Then search using keywords such as Oracle 2022.

Note

The following lists are not exhaustive.

New features in RDS for Oracle

To see new features in RDS for Oracle, use the following techniques:

• Search Document history for the keyword Oracle.

• Filter new Amazon RDS features on the What's New with Database? page. For Products, choose Amazon RDS. Then search for Oracle YYYY, where YYYY is a year such as 2024.

Supported features in RDS for Oracle

Amazon RDS for Oracle supports the following Oracle Database features:

• Advanced Compression

• Application Express (APEX)

  For more information, see Oracle Application Express (APEX).

• Automatic Memory Management

• Automatic Undo Management

• Automatic Workload Repository (AWR)

  For more information, see Generating performance reports with Automatic Workload Repository (AWR).

• Active Data Guard with Maximum Performance in the same AWS Region or across AWS Regions

  For more information, see Working with read replicas for Amazon RDS for Oracle.

• Blockchain tables (Oracle Database 21c and higher)

  For more information, see Managing Blockchain Tables in the Oracle Database documentation.

• Continuous Query Notification

  For more information, see Using Continuous Query Notification (CQN) in the Oracle documentation.

• Data Redaction

• Continuous Query Notification

  For more information, see Database Change Notification in the Oracle documentation.

• Database In-Memory

• Distributed Queries and Transactions

• Edition-Based Redefinition

  For more information, see Setting the default edition for a DB instance.

• EM Express (12c and higher)

  For more information, see Oracle Enterprise Manager.

• Fine-Grained Auditing

• Flashback Table, Flashback Query, Flashback Transaction Query

• Gradual password rollover for applications (Oracle Database 21c and higher)

  For more information, see Managing Gradual Database Password Rollover for Applications in the Oracle Database documentation.

• HugePages

  For more information, see Turning on HugePages for an RDS for Oracle instance.

• Import/export (legacy and Data Pump) and SQL*Loader

  For more information, see Importing data into Oracle on Amazon RDS.

• Java Virtual Machine (JVM)

  For more information, see Oracle Java virtual machine.

• JavaScript (Oracle Database 21c and higher)

  For more information, see DBMS_MLE in the Oracle Database documentation.

• Label Security

  For more information, see Oracle Label Security.

• Locator

  For more information, see Oracle Locator.

• Materialized Views

• Multitenant

  The Oracle multitenant architecture is supported for all Oracle Database 19c and higher releases. For more information, see Working with CDBs in RDS for Oracle.

• Network encryption

  For more information, see Oracle native network encryption and Oracle Secure Sockets Layer.

• Partitioning

• Real Application Testing

  To use the full capture and replay capabilities, you must use Amazon Elastic File System (Amazon EFS) to access files generated by Oracle Real Application Testing. For more information, see Amazon EFS integration and the blog post Use Oracle Real Application Testing features with Amazon RDS for Oracle.

• Sharding at the application level (but not the Oracle Sharding feature)

• Spatial and Graph

  For more information, see Oracle Spatial.

• Star Query Optimization

• Streams and Advanced Queuing

• Summary Management – Materialized View Query Rewrite

• Text (File and URL data store types are not supported)

• Total Recall

• Transparent Data Encryption (TDE)

  For more information, see Oracle Transparent Data Encryption.

• Unified Auditing, Mixed Mode

  For more information, see Mixed mode auditing in the Oracle documentation.

• XML DB (without the XML DB Protocol Server)

  For more information, see Oracle XML DB.

• Virtual Private Database

Unsupported features in RDS for Oracle

Amazon RDS for Oracle doesn't support the following Oracle Database features:

• Automatic Storage Management (ASM)

• Database Vault

• Flashback Database

  Note

  For alternative solutions, see the AWS Database Blog entry Alternatives to the Oracle flashback database feature in Amazon RDS for Oracle.

• FTP and SFTP

• Hybrid partitioned tables

• Messaging Gateway

• Oracle Enterprise Manager Cloud Control Management Repository

• Real Application Clusters (Oracle RAC)

• Real Application Security (RAS)

• Unified Auditing, Pure Mode

• Workspace Manager (WMSYS) schema

Note

The preceding list is not exhaustive.

Warning

In general, Amazon RDS doesn't prevent you from creating schemas for unsupported features. However, if you create schemas for Oracle features and components that require SYSDBA privileges, you can damage the data dictionary and affect the availability of your DB instance. Use only supported features and schemas that are available in Adding options to Oracle DB instances.