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
Dec 2
2025
New capabilities to optimize costs and improve scalability on Amazon RDS for SQL Server and Oracle
May 7
2024
Minimize downtime when migrating your Oracle database to Amazon RDS for Oracle with transportable tablespaces and AWS DMS
Jan 14
2026
Effectively managing storage in Amazon RDS for Oracle Databases

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.