In the production Oracle environment, it is essential to change AWR retention and performance data snapshot collection frequency from 1-hour to 15 minutes. Our F500 major clients use 15 minutes with no impact on production performance. Having 15 minutes of data snapshots vs. 1 hour dramatically increases the ability to troubleshoot. Also, AWR data contains ASH information collected from memory. Switch to 15 minutes collection intervals dramatically improves the quality of ASH information.
Two weeks is the default period of retention. At least four months of AWR data is required in a production context compared to four months of monthly seasonal data. Compare one month from the current quarter to the same month from the previous quarter. As a result, storing new gigabytes of AWR data is not a budgetary issue. Also, we strongly suggest keeping 13 months of data to investigate annual seasonality.
Below command switches AWR to 4 months (172800 minutes) data retention and 15 minutes collection frequency.
exec DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(retention => 172800,interval => 15);
Overall, keeping several years of AWR performance data for capacity planning and predictive analytics employing advanced machine learning technologies to discover and predict mid-and long-term performance trends and probable “Black-Swan” events. Events that have the potential to dramatically and catastrophically impair the production environment will hold.
For these purposes, Oracle introduced The Enterprise Manager AWR Warehouse. As a result, Enteros UpBeat fully supports database performance analysis across AWR Warehouses and individual production database systems.
Enteros’ expert team has deep expertise in predictive analytics on database performance data. Contact us at support@enteros.com, and we will gladly discuss how our experts can create machine and deep learning models to predict the performance of your critical database systems.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Why BFSI Leaders Are Turning to Enteros for Database Optimization, AI Ops, and Cloud FinOps Excellence
- 16 April 2026
- Database Performance Management
Introduction The Banking, Financial Services, and Insurance (BFSI) sector is undergoing a massive digital transformation. With the rise of digital banking, real-time payments, fraud detection systems, and AI-driven financial services, organizations are becoming increasingly dependent on high-performance data infrastructure. From managing millions of transactions per second to enabling real-time risk analysis and personalized customer experiences, … Continue reading “Why BFSI Leaders Are Turning to Enteros for Database Optimization, AI Ops, and Cloud FinOps Excellence”
How to Optimize Telecom Sector Growth with Enteros AIOps Platform, Resource Metadata, Hierarchy Metadata, Spot Instances, and RevOps Efficiency
Introduction The telecom sector is at the center of global digital transformation, enabling connectivity for billions of users, businesses, and emerging technologies like IoT, 5G, and edge computing. As demand for high-speed, reliable communication services continues to rise, telecom providers are under immense pressure to scale operations efficiently while maintaining performance and controlling costs. However, … Continue reading “How to Optimize Telecom Sector Growth with Enteros AIOps Platform, Resource Metadata, Hierarchy Metadata, Spot Instances, and RevOps Efficiency”
Who Should Adopt Enteros for Retail Growth Management with AI SQL and Cloud FinOps Efficiency
Introduction The retail sector is evolving at an unprecedented pace, driven by digital transformation, omnichannel experiences, and data-driven decision-making. From global eCommerce giants to mid-sized retail chains, businesses are increasingly relying on cloud infrastructure, databases, and analytics platforms to fuel growth. However, this rapid expansion introduces a fundamental challenge:how to scale efficiently while maintaining performance, … Continue reading “Who Should Adopt Enteros for Retail Growth Management with AI SQL and Cloud FinOps Efficiency”
How to Optimize Technology Sector Growth with Enteros Database Management Platform, Cloud FinOps, and RevOps Efficiency
Introduction The technology sector is at the forefront of innovation, powering digital transformation across industries. From SaaS platforms and cloud-native applications to AI-driven solutions, technology companies are scaling rapidly to meet growing global demand. However, this rapid expansion introduces a critical challenge:how to sustain growth while maintaining high-performance systems, controlling cloud costs, and aligning operations … Continue reading “How to Optimize Technology Sector Growth with Enteros Database Management Platform, Cloud FinOps, and RevOps Efficiency”