AHF Release 24.8

Share Problem Summary as Text and Detect New Problems

In this release, AHF introduces enhanced functionality for managing and sharing problem summaries. You can now copy the contents of the AHF Problem Summary as plain text, making it easier to share information. Additionally, AHF has been updated to detect and provide resolutions for new problems.

Since version 24.4, AHF has had the capability to detect issues and present a summary along with resolutions (Node Eviction Detection and Resolution). The Problem Summary page is accessible under the Detected Problems panel in Insights.

With this update, the ability to copy the Problem Summary as plain text has been added, simplifying the process of sharing this information. Additionally, AHF has been enhanced to detect and provide resolutions for the following new issues:
  • Node eviction due to:
    • IP Reassembly Failures
    • PGA configuration issue
  • Slow performance due to:
    • DB Writer configuration issue
    • Latch contention due to target_pdbs setting
  • Database blocks due to:
    • Archiver blocked due to insufficient space in the diskgroup
    • Archiver blocked due to IO error

For more information, see Explore Diagnostic Insights.

Timeline and Operating System Issues Usability Improvements

AHF Insights has introduced enhancements to both the Timeline and Operating System (OS) Issues sections, offering more detailed analysis and improved usability.

Timeline

  • The Timeline feature provides a comprehensive overview of all events detected by AHF, allowing you to identify the root cause of issues even when AHF doesn't have exact information. From the Insights home screen, you can access the Timeline, which displays all detected events.
  • You can hover over any event for more details and zoom in by dragging around a group of events, making it easier to trace the sequence of events that led to the problem.
  • With this release, the Timeline now offers millisecond granularity, enabling even more precise analysis. Hovering over an event will reveal detailed information, including the full timestamp.

Operating System Issues

  • The OS Issues section helps you understand the state of the operating system, presenting detected problems in a timeline view along with a list of significant events and findings.
  • In this release, if no OS issues are detected, the page will automatically redirect you to the data analysis tab, streamlining your navigation and helping you focus on relevant data.

For more information, see Explore Diagnostic Insights.

Data Guard Section Gets a Major Upgrade

The Data Guard section has undergone a significant transformation to enhance your experience, making it smoother, faster, and more insightful.

  • Sleek New Design: Data Guard is now seamlessly integrated into the Insights report, providing one-click access to your environments. No more searching—just instant access to the information you need. The UI/UX of the Data Guard section has been completely overhauled, offering a more intuitive and user-friendly design.
  • Introducing the New Data Configuration Page: New features like Switchover Readiness and Failover Readiness computed values have been introduced, eliminating the need for manual calculations and saving you time.
  • Database Symmetry Information at Your Fingertips: When you drill down into a database, you’ll now see a summary of Database Symmetry information. This feature aligns with the Standard Oracle Recommendation, making it easier than ever to ensure symmetry and keep you ahead of the curve.
  • All-New Database Wait Events Table: A comprehensive table of Wait Events Records has been added to the drill-down view, helping you quickly identify and address potential bottlenecks, which is crucial for understanding your database’s performance.
  • Centralized Database Details: All the essential database details, such as Configuration Details, Configuration Changes, and Properties Changes, are now consolidated into a new page: Additional Details. Everything you need is neatly organized in one place.

For more information, see Explore Diagnostic Insights.

New Additional Reports Section in Insights

With this update, you can now access contextual performance reports like Automatic Workload Repository (AWR) Reports, AWR Compare Reports, and Perfhub Reports directly from the Insights report. These reports help identify issues related to workload, SQLs, and other performance areas, providing a more comprehensive analysis.

In previous versions, these details were not available in the Insights report. Now, users can easily open the "Additional Reports" section from the Insights Report and correlate AHF Insights' findings with the information in these additional reports.

The "Additional Reports" section currently supports:

  • AWR Reports
  • AWR Compare Reports
  • Perfhub Reports

How to Generate and Access Insights Reports:

  1. Use the command: ahf analysis create --type insights to generate the Insights report.
  2. Copy the generated Insights zip file to a system with browser support.
  3. Extract the zip file.
  4. Open index.html.
  5. Click on the "Additional Reports" section to view the reports.

For more information, see Explore Diagnostic Insights.

Oracle JET Virtual DOM Architecture

The AHF Insights interface has been upgraded from the Model-View-ViewModel (MVVM) architecture to a Virtual DOM architecture, with Oracle JET being updated to version 16.0.1.

Key benefits of migrating to Virtual DOM architecture include:
  • Faster initial load times for reports.
  • Improved rendering performance, leading to a smoother, more responsive user experience.
  • Enhanced error handling.

AHF Balance Disaster Recovery Support

AHF Balance now provides enhanced recommendations for Database Resource Manager settings to minimize noisy neighbor issues, especially in disaster scenarios.

AHF Balance recommends CPU_COUNT settings based on the last month's CPU usage history. In the case of Disaster Recovery Standby databases, the recorded CPU usage is typically low. However, if a Disaster Recovery Standby becomes a Primary database during a disaster, its CPU usage would significantly increase. Without considering this possibility, the recommended CPU_COUNT might be insufficient to handle the Primary load.

AHF Balance now factors in Disaster Recovery configurations to estimate what the CPU usage would have been if a disaster had occurred at the beginning of the data collection period and persisted throughout. These estimates allow for more accurate CPU_COUNT recommendations that account for both normal operations and potential disaster conditions.

Figure -11 AHF Balance Disaster Recovery


This image illustrates AHF Balance disaster recovery

Balance Reports: When Disaster Recovery is configured, Balance reports now include three scenarios:
  • Current: Displays Exposure and Impact based on current CPU_COUNT settings and actual CPU usage history from the last month.
  • Disaster: Shows expected Exposure and Impact based on current CPU_COUNT settings, using estimated CPU usage in a disaster scenario.
  • Recommended: Provides expected Exposure and Impact if the recommended CPU_COUNT settings were applied, considering the estimated CPU usage during a disaster.

For more information on how to resolve noisy neighbor issues using AHF Balance, see Resolve Noisy Neighbor Issues.

New Oracle Orachk and Oracle Exachk Best Practice Checks

Release 24.8 includes the following new Oracle Orachk and Oracle Exachk best practice checks.

Oracle Exachk Specific Best Practice Checks

  • Exadata Critical Issue DB54

All checks can be explored in more detail via the Health Check Catalogs: