Posted On: Sep 14, 2022
Amazon Relational Database Service (Amazon RDS) for Oracle now supports the instance store for temporary tablespaces and the Database Smart Flash Cache (flash cache) for M5d and R5d instances. M5d and R5d instances are ideal fit for applications that need access to high-speed, low latency local storage including those that need temporary storage of data for scratch space, temporary files, and caches.
With M5d and R5d instances, You can now place the temporary tablespaces in the instance store. A database session can write temporary, intermediate data to a temporary tablespace, and then read the data back into memory for processing. This strategy improves throughput for sorts, hash aggregations, high-load joins, and much more. The temporary tablespaces feature is available in both Oracle Database Enterprise Edition (EE) and Oracle Database Standard Edition 2 (SE2).
Furthermore, you can also configure a flash cache in the instance store. The flash cache works well for read-intensive workloads that use mostly single-block random reads. As a best practice, size the cache to hold a large portion of the active data set that doesn't fit in the buffer cache. Without the flash cache, queries read data from EBS storage, which has a higher latency than local storage. With the flash cache, queries can read data blocks from the cache, which improves performance. The flash cache is available in Oracle Database Enterprise Edition (EE).
M5d and R5d instances for RDS for Oracle are available today in the following AWS Regions: US East (Ohio), US East (N. Virginia), US West (N. California), and US West (Oregon), Africa (Cape Town), Asia Pacific (Hong Kong), Asia Pacific (Mumbai), Asia Pacific (Osaka), Asia Pacific (Seoul), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), AWS GovCloud (US), Canada (Central), Europe (Frankfurt), Europe (Ireland), Europe (London), Europe (Milan), Europe (Paris), Europe (Stockholm), Middle East (Bahrain), South America (Sao Paulo).
M5d and R5d instances are available in 8 sizes with 2, 4, 8, 16, 32, 48, 64, and 96 vCPUs. You can launch the new instances in the Amazon RDS Management Console or using the AWS CLI. M5d and R5d instances are the local disk variants of the R5 and M5 instance families backed by NVMe-based SSD block level instance storage physically connected to the host server. These include up to 3,600 GiB of Non-Volatile Memory Express (NVMe) SSD-based instance storage optimized for low latency, very high random I/O performance, and high sequential read throughput workloads.
See Amazon RDS for Oracle Pricing for up-to-date pricing and regional availability.