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

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.

Topics

• New features in RDS for Oracle
• Supported features in RDS for Oracle
• Unsupported features in RDS for Oracle

New features in RDS for Oracle

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

• Search Document history for the keywordOracle.
• Filter new Amazon RDS features on the What's New with Database? page. For Products, select Amazon RDS. Then search for Oracle `YYYY`, whereYYYY is a year such as2025.

Supported features in RDS for Oracle

Amazon RDS for Oracle supports the following Oracle Database features:

Note

The following list isn't exhaustive.

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

Note

The following list isn't exhaustive.

• Automatic Storage Management (ASM)
• Database Vault
• Flashback Database

Note

• 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

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.