Home icon

Enhancing performance of Amazon RDS for Oracle with NVMe SSD hosted Smart Flash Cache and Temporary Tablespaces

Database Blog

This article discusses how Amazon RDS for Oracle can enhance performance using NVMe SSD-based instance storage for temporary tablespaces and Smart Flash Cache.

  • Temporary tablespaces on instance storage can significantly speed up queries with high temporary space usage
  • Flash Cache allows Oracle Database to expand memory cache to local NVMe SSD storage
  • Benefits include:
    • 75% faster block fetches compared to EBS
    • Reduced read latency
    • Higher throughput
    • Potential cost optimization by using smaller instances
  • Performance tests showed:
  • 61% reduction in query runtime
  • 94.79% improvement in query performance with Flash Cache
  • Significant reduction in buffer gets and wait times

The feature is available on specific instance types like m5d, r5d, x2idn, and x2iedn, offering a cost-effective way to improve database performance.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Dec 17
2024
Migrating Oracle Databases from Exadata to Amazon RDS for Oracle: Addressing Performance Considerations
Nov 15
2024
Optimize your database storage for Oracle workloads on AWS, Part 2: Using hybrid partitioning and ILM data movement policies
Nov 15
2024
Optimize your database storage for Oracle workloads on AWS, Part 1: Using ADO and ILM data compression policies
Dec 26
2024
Backing up Oracle databases to Amazon S3 at scale

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.