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
The Role of AIOps and FinOps in Building Resilient, Cost-Efficient Enterprise IT Infrastructure
- 21 August 2026
- Database Performance Management
Introduction Enterprise IT infrastructure has evolved from relatively centralized environments into highly distributed ecosystems spanning cloud platforms, on-premises data centers, SaaS applications, microservices, containers, and increasingly data-intensive workloads. While this transformation provides organizations with greater agility and scalability, it also introduces significant operational and financial complexity. IT teams are expected to maintain high availability, deliver … Continue reading “The Role of AIOps and FinOps in Building Resilient, Cost-Efficient Enterprise IT Infrastructure”
How AIOps, FinOps, and AI-Powered Database Intelligence Drive Industry-Wide Digital Transformation
Introduction Digital transformation has moved beyond simply adopting cloud infrastructure or modernizing legacy applications. Organizations across banking, BFSI, healthcare, education, retail, telecommunications, manufacturing, and other industries are building increasingly complex digital ecosystems that must deliver high performance, continuous availability, scalability, and cost efficiency. At the center of this transformation are three complementary capabilities: AIOps, FinOps, … Continue reading “How AIOps, FinOps, and AI-Powered Database Intelligence Drive Industry-Wide Digital Transformation”
How to Optimize Fashion and Apparel Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
Introduction Fashion and apparel companies are increasingly digital businesses. Ecommerce, mobile commerce, inventory management, supply chain platforms, customer analytics, personalization, merchandising, and omnichannel retail have transformed how fashion brands operate. Every product search, online order, inventory update, return, payment, customer interaction, and marketing campaign depends on enterprise databases. Enteros helps fashion organizations optimize these environments … Continue reading “How to Optimize Fashion and Apparel Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”
How to Optimize Professional Services Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability
Introduction Professional services organizations—including consulting firms, legal organizations, accounting firms, engineering companies, and business advisory firms—are increasingly dependent on digital platforms. Client management, project delivery, financial management, resource allocation, billing, document management, analytics, and collaboration all depend on enterprise applications and databases. Enteros helps professional services organizations optimize these systems through Database Observability, AI-powered Analytics, … Continue reading “How to Optimize Professional Services Operations with Enteros Database Software, AI-Powered Analytics, and Database Observability”