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
Transforming BFSI Cloud Efficiency: How Enteros Enhances Budgeting and Governance Through the Cloud Center of Excellence
- 13 November 2025
- Database Performance Management
Introduction In the fast-evolving world of Banking, Financial Services, and Insurance (BFSI), cloud transformation has become more than a technological upgrade—it’s a strategic imperative. As financial institutions adopt multi-cloud and hybrid ecosystems, managing cost efficiency, compliance, and performance governance becomes increasingly complex. To meet these challenges, many organizations are establishing Cloud Centers of Excellence (CCoE)—dedicated … Continue reading “Transforming BFSI Cloud Efficiency: How Enteros Enhances Budgeting and Governance Through the Cloud Center of Excellence”
Revolutionizing Healthcare Efficiency: How Enteros Integrates AIOps and Cloud FinOps to Transform Database Performance Management
Introduction In the modern era of digital healthcare, data drives everything—from clinical decision-making and patient outcomes to financial operations and regulatory compliance. As healthcare organizations increasingly adopt cloud technologies, electronic health records (EHRs), and AI-based analytics, the volume and complexity of data have grown exponentially. This digital transformation has brought immense potential for innovation but … Continue reading “Revolutionizing Healthcare Efficiency: How Enteros Integrates AIOps and Cloud FinOps to Transform Database Performance Management”
Maximizing RevOps Efficiency: How Enteros Leverages Generative AI and Cloud FinOps to Redefine Business Performance Optimization
- 12 November 2025
- Database Performance Management
Introduction In today’s fast-paced digital economy, achieving seamless alignment between revenue, operations, and finance has become the ultimate competitive advantage. Businesses are no longer just managing data—they’re orchestrating vast ecosystems of cloud infrastructure, applications, and databases that drive revenue generation and operational agility. However, as organizations scale across multi-cloud environments, the challenge of balancing performance, … Continue reading “Maximizing RevOps Efficiency: How Enteros Leverages Generative AI and Cloud FinOps to Redefine Business Performance Optimization”
Advancing Healthcare Innovation: How Enteros Integrates AIOps and Observability Platforms to Redefine Database Performance Management
Introduction The healthcare industry is undergoing a digital renaissance. From electronic health records (EHR) and telemedicine to AI-powered diagnostics and predictive patient analytics, healthcare systems now depend on massive data ecosystems that must function with precision and reliability. However, as these data systems scale, the complexity of maintaining consistent database performance, cost efficiency, and operational … Continue reading “Advancing Healthcare Innovation: How Enteros Integrates AIOps and Observability Platforms to Redefine Database Performance Management”