@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“Insights”

Insights

Note: Database Server section will not be displayed in a non-Exadata environment.

Timeline

Starting with AHF 24.10, you can open the log or trace file associated with an event directly from the AHF Insights timeline. Selecting an event opens the file in the File Viewer at the location where the event was recorded.

The Timeline section displays significant database-related events in chronological context. It provides graphical and tabular views that help you correlate events across hosts, databases, Oracle components, and specific points in time.

To use the Timeline, open an AHF diagnostic collection, extract the AHF Insights report, and select Timeline from the Home page.

Use the Timeline to:

After opening a file in the File Viewer, you can browse the complete contents of the log or trace file and search for specific information.

Operating System Issues

The Operating System Issues section provides information about operating system configuration, system metrics, and detected anomalies. It helps you investigate resource usage and identify issues related to CPU, memory, I/O, processes, and network activity.

The section provides three views:

AHF 23.8 Enhancements

Starting with AHF 23.8, the Operating System Issues user interface includes enhancements that make it easier to identify disk anomalies and analyze operating system processes.

You can:

AHF 23.10 Enhancements

Starting with AHF 23.10, plots provide additional data points for problematic time ranges to support more detailed analysis.

For problematic time ranges, data is displayed at the following intervals:

Time Range Reading Interval
Less than 1 minute 5 seconds
More than 1 minute 30 seconds

The number of data points displayed in Operating System Issues plots is adjusted dynamically to optimize report generation time.

For time ranges longer than four hours, the number of data points is reduced using the following intervals:

Time Range Reading Interval
Up to 4 hours 1 minute
More than 4 hours and less than 12 hours 3 minutes
More than 12 hours 5 minutes

AHF 23.11 Enhancements

Starting with AHF 23.11, you can view data collected by Exawatcher.

You can visualize data from both cell and compute nodes and switch between them using the node selector:

For cell nodes, you can examine metrics for:

Configuration

The Configuration view displays operating system configuration information for the systems from which metrics were collected.

The configuration information includes:

Metrics

The Metrics view provides graphical representations of operating system metrics. Green and red status indicators help identify the state of the monitored resources.

Use the node selector in the upper-right corner to select the node whose metrics you want to examine.

Use the calendar control to select the time range for which you want to display metrics.

The Metrics view provides information about system overview, CPU, memory, local I/O, processes, network activity, and process aggregation.

System Overview

Provides an overview of system resources, including:

You can:

CPU Metrics

Displays CPU utilization and related metrics.

You can:

Memory Metrics

Displays system memory metrics.

You can:

Local I/O Metrics

Displays local system I/O metrics and helps identify storage-related performance issues.

You can:

Process Metrics

Displays operating system process metrics.

You can:

Network Metrics

Displays network interface and protocol-related metrics.

You can:

Process Aggregation Metrics

Displays aggregated process metrics organized by process or instance group.

You can:

Report

The Report view provides a widescreen view of detected operating system findings and lets you investigate them in greater detail.

The report includes:

Use the report to:

The Problematic Snapshots section organizes problem-specific system snapshots by timestamp, allowing you to drill down into the system state associated with each detected issue.

Best Practice Issues

Starting with AHF 23.8, compliance checks from Oracle Orachk and Oracle Exachk are integrated into the Best Practice Issues section of AHF Insights.

Oracle Autonomous Health Framework (AHF) includes thousands of Best Practice Compliance Checks that Oracle Orachk and Oracle Exachk run automatically. You can view the results of these checks in HTML reports or consume the results in JSON and XML formats using other tools.

AHF Insights integrates these Best Practice Compliance Checks into a unified interface for on-demand compliance analysis. It helps you quickly assess the overall health of the system, identify areas that do not comply with recommended best practices, and determine the corrective actions required.

Use the Best Practice Issues section to:

Continue to use Oracle Orachk and Oracle Exachk commands for automated and scheduled compliance checks. For an on-demand compliance investigation, generate an AHF Insights report:

ahf analysis create --type insights

The Best Practice Issues section displays the results of Best Practice Compliance Checks performed on the system. Results are paginated and include information about:

Use the available controls to explore and customize the report:

System Change

The System Change section provides a paginated view of changes detected or applied across the system, helping you identify configuration and environmental changes that might be relevant to system behavior or an issue under investigation.

Use the available controls to refine the information displayed:

Starting with AHF 23.8, you can copy recommended software information in text format to the clipboard and paste it into the body of a Service Request (SR).

The Recommended Software section lists recommended software and provides links to the corresponding supported versions.

Click Copy Snippet to copy the recommended version information to the clipboard.

Database Server

The Database Server section provides information collected by the Management Server. It includes two views:

The Metrics view provides information about Management Server performance and resource utilization. The Alerts view provides information about hardware, software, and Automatic Diagnostic Repository (ADR) alerts recorded by the Management Server.

Metrics

The Metrics view displays Management Server metrics, including:

Select a host from the list to view its Management Server metrics.

Alerts

The Alerts view displays alerts recorded by the Management Server across hardware, software, and ADR.

You can review alerts using the following views:

The Table view displays alert details, including the alert description and recommended remedial action.

You can:

The Graph view categorizes alerts by:

Use Show open alerts to display only open alerts. This option is enabled by default.

For more information, see:

RPM List

The RPM List section lists installed RPMs and highlights differences in RPM configurations across nodes.

The RPM information includes:

Use the available controls to review and compare RPM information:

Database Parameters

The Database Parameters section lists normal and hidden Oracle Database parameters and enables you to compare parameter properties across multiple databases.

The section provides two views:

Use the available controls to review and compare database parameters:

Kernel Parameters

The Kernel Parameters section lists kernel parameters and enables you to compare their properties across multiple hosts or nodes.

Use the available controls to review and compare kernel parameters:

Patch Information

The Patch Information section provides information about patches applied across the system. It helps you track which patches were applied, where they were applied, and when they were applied.

AHF Insights identifies patching gaps or inconsistencies across nodes that use the same Oracle home. It also provides information about the bugs fixed by individual patches and enables you to search patch and bug information using interactive reports.

The section provides two views:

Patches

The Patches view provides a timeline of applied patches and information about the hosts and Oracle homes where the patches were installed.

Use the available controls to review patch information:

Components

The Components view provides a paginated list of components and their versions affected by applied patches.

Space Analysis

The Space Analysis section provides information about disk utilization and the amount of disk space consumed by diagnostic data.

The section provides two views:

Disk Utilization

The Disk Utilization view provides paginated, host-specific information about:

Use this information to identify directories or files that consume significant disk space and assess the available capacity on each host.

Diagnostic Space Usage

The Diagnostic Space Usage view provides paginated information about the disk space consumed by diagnostic data.

Use the available filters to:

Database Anomalies Advisor

The Database Anomalies Advisor detects database anomalies, identifies potential causes, and recommends corrective actions.

It provides a summary timeline of anomalies detected across hosts and Oracle Database instances. You can drill down into individual findings to understand the issue, its potential cause, and the recommended corrective action.

To view the Database Anomalies Advisor:

  1. Generate an AHF Insights report:

    ahf analysis create --type insights
  2. Open the generated AHF Insights report.
  3. Click Database Anomalies Advisor.
  4. Review the detected anomalies and drill down into individual findings to view their causes and recommended corrective actions.

Performance Reports

Performance Reports provide diagnostic information for monitoring and analyzing Oracle Database performance. Database administrators can use these reports to identify performance bottlenecks, resource-intensive SQL statements, workload trends, and other issues that can affect database performance.

AHF Insights provides the following performance reports:

To collect diagnostic data for database performance analysis, run the dbperf Service Request Data Collection (SRDC):

tfactl diagcollect -srdc dbperf -database <db_name>

How Performance Reports Help

Use performance reports to:

Supported Systems and Platforms

Performance reports can be generated for Oracle Database environments running on systems such as:

Performance reports are supported on applicable operating system platforms, including Linux and Oracle Solaris.

Automatic Workload Repository Reports

Automatic Workload Repository (AWR) collects, processes, and maintains Oracle Database performance statistics. An AWR report summarizes database performance over a selected time period.

An AWR report can include:

Use AWR reports to identify performance bottlenecks, investigate resource-intensive SQL statements, and identify opportunities for database performance optimization.

Note: AWR is part of the Oracle Diagnostics Pack and requires the appropriate license. Verify licensing requirements before using AWR functionality.

AWR Compare Reports

AWR Compare Reports compare database performance between two time periods. Use these reports to identify changes in database behavior and determine how performance metrics differ between the selected periods.

An AWR Compare Report can include comparisons of:

AWR Compare Reports are particularly useful when investigating performance changes associated with events such as:

Comparing a period of normal performance with a period of degraded performance can help identify the conditions associated with a performance issue.

Performance Hub Reports

Performance Hub (PerfHub) Reports provide an interactive graphical view of database performance information, enabling you to explore workload and performance data from a consolidated interface.

A Performance Hub report can include:

Use Performance Hub reports to analyze database activity, identify SQL statements or resources contributing to performance problems, and investigate performance behavior over time.

For more information about AWR Reports and Performance Hub Active Reports, see Gathering Database Statistics in the Oracle Database Performance Tuning Guide.