Posted On: Dec 21, 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 in the Amazon Web Services China (Ningxia) Region, operated by NWCD, and the Amazon Web Services China (Beijing) Region, operated by Sinnet.
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 so on. 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 higher latency than local store. 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 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.
Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See Amazon RDS for Oracle Database Pricing for regional availability.