Optimize your database storage for Oracle workloads on AWS, Part 1: Using ADO and ILM data compression policies
Database Blog
This blog post discusses techniques to optimize storage for Oracle database workloads on AWS using Oracle's built-in features like Heat Map, Automatic Data Optimization (ADO), and Information Lifecycle Management (ILM) policies. It covers two approaches:
Specifically, the article covers:
- Enabling Heat Map tracking and setting up a sample partitioned table
- Automatic data compression based on data access pattern using ADO segment-level and row-level compression policies
- How ADO leverages Heat Map data and ILM policies to automate compression of infrequently accessed data
- Examples demonstrating the compression policies and their impact on storage reduction
- Conclusion summarizing the benefits of using these Oracle features on AWS for optimizing database storage
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
Nov 15
2024
2024
Optimize your database storage for Oracle workloads on AWS, Part 2: Using hybrid partitioning and ILM data movement policies
Jan 14
2026
2026
Effectively managing storage in Amazon RDS for Oracle Databases
Dec 23
2024
2024
Enhancing performance of Amazon RDS for Oracle with NVMe SSD hosted Smart Flash Cache and Temporary Tablespaces
Dec 17
2024
2024
Migrating Oracle Databases from Exadata to Amazon RDS for Oracle: Addressing Performance Considerations
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.