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
Improving Student Experience Through AI-Powered Database Performance Monitoring in Higher Education
- 7 July 2026
- Database Performance Management
Introduction Higher education is undergoing a profound digital transformation. Universities and colleges increasingly rely on technology to deliver personalized learning experiences, streamline campus operations, and provide students with seamless access to academic resources. From online admissions and learning management systems (LMS) to student information systems (SIS), digital libraries, research platforms, financial aid portals, and campus … Continue reading “Improving Student Experience Through AI-Powered Database Performance Monitoring in Higher Education”
Building Resilient Digital Services with AIOps, FinOps, and AI-Driven Database Observability
Introduction Digital services have become the backbone of modern enterprises. Whether customers are transferring money through mobile banking apps, scheduling telehealth appointments, shopping online, managing supply chains, or accessing government portals, they expect seamless, secure, and always-available digital experiences. Even a brief interruption can lead to lost revenue, reduced customer trust, regulatory concerns, and operational … Continue reading “Building Resilient Digital Services with AIOps, FinOps, and AI-Driven Database Observability”
How Intelligent SQL Optimization Reduces Cloud Costs Across BFSI and Healthcare
- 6 July 2026
- Database Performance Management
Introduction Cloud computing has transformed how organizations in Banking, Financial Services, and Insurance (BFSI) and healthcare deliver digital services. From real-time payment processing and fraud detection to electronic health records (EHRs), telemedicine, and AI-powered analytics, cloud platforms provide the scalability and flexibility needed to support mission-critical applications. However, as cloud adoption grows, so do operational … Continue reading “How Intelligent SQL Optimization Reduces Cloud Costs Across BFSI and Healthcare”
How FinOps and Database Performance Analytics Improve Enterprise Cloud ROI
Introduction Cloud computing has become the foundation of digital transformation for modern enterprises. Organizations across industries—including banking, healthcare, telecommunications, retail, manufacturing, and SaaS—are increasingly relying on public, private, and hybrid cloud environments to deliver scalable applications, accelerate innovation, and improve operational agility. While the cloud offers tremendous flexibility, it has also introduced a new challenge: … Continue reading “How FinOps and Database Performance Analytics Improve Enterprise Cloud ROI”