Amazon Relational Database Service (Amazon RDS) for Oracle now supports R6id and M6id instances. These instances offer up to 7.6 TB of NVMe-based local storage, making them well-suited for database workloads that require access to large amounts of intermediate data beyond the instance’s memory capacity. Customers can configure their Oracle database to use the local storage for temporary tablespace and Database Smart Flash Cache.
Operations such as sorts, hash joins, and aggregations can generate large amounts of intermediate data that doesn’t fit in memory and is stored in temporary tablespace. With R6id and M6id, Customers can place temporary tablespaces in the local storage instead of the Amazon EBS volume attached to their instance to reduce latency, improve throughput, and lower the provisioned IOPS.
Customers with Oracle Enterprise Edition license can configure Database Smart Flash Cache to use the local storage. When configured, Smart Flash Cache will use the local storage to keep frequently accessed data that doesn’t fit in memory and improve the read performance of the database.
You can launch the new instance in the Amazon RDS Management Console or using the AWS CLI. Refer Amazon RDS for Oracle Pricing for available instance configurations, pricing details, and region availability.