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:

Select Component Faceted View from the Select timeline filter to group events by Oracle components, such as RDBMS, CRS, and OS.
Select Database Faceted View from the Select timeline filter to group events by database.
Click Copy Snippet to copy event details to the clipboard.
Click View in the Open in File Viewer column to open the associated log or trace file. The View button is available only when the event is associated with a file containing event details. The File Viewer opens the file at the line where the event was recorded.
Review the Triggering Events section at the top of the Timeline. If an automated collection, such as an SRDC, generated the Insights report, this section displays the event that triggered the report.
Use the filters to search for specific values.
Filter events by a specific time range.
Click the arrow next to a date to view detailed information for a specific timestamp.
Hover over a data point in the graph to view details for that point in time.
Zoom in on the timeline for a more detailed view.

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:

Configuration
Metrics
Report

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:

Identify disks with anomalies. Under Local I/O, click Disk to view Disk Metrics. Disks with detected anomalies are marked with an X.
Analyze process aggregation by instance group, such as:
- Databases
- ASM
- APX (Apex)
- IOS
- Clusterware
Use category-specific legends instead of a single legend shared across all process categories.

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:

(S) identifies cell nodes.
(D) identifies compute nodes.

For cell nodes, you can examine metrics for:

Flash disks
Flash disk aggregates
Hard disk aggregates

Configuration

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

The configuration information includes:

CPU
Memory
I/O
Network

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:

CPU
Memory
Processes
I/O operations

You can:

Hover over a point on a graph to view detailed information for that point in time.
Zoom in on the timeline for more detailed analysis.

CPU Metrics

Displays CPU utilization and related metrics.

You can:

Hover over a point on a graph to view detailed information.
Zoom in on the timeline.

Memory Metrics

Displays system memory metrics.

You can:

Hover over a point on a graph to view detailed information.
Zoom in on the timeline.

Local I/O Metrics

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

You can:

Hover over a point on a graph to view detailed information.
Zoom in on the timeline.
Select Disk to examine individual disk metrics and identify disks with detected anomalies.

Process Metrics

Displays operating system process metrics.

You can:

Hover over a point on a graph to view detailed information.
Zoom in on the timeline.

Network Metrics

Displays network interface and protocol-related metrics.

You can:

Select metrics for network interfaces, IP, UDP, and TCP.
Hover over a point on a graph to view detailed information.
Zoom in on the timeline.

Process Aggregation Metrics

Displays aggregated process metrics organized by process or instance group.

You can:

Select a node from the Select Node list to display node-specific process aggregation metrics.
Review process groups such as databases, ASM, APX, IOS, and Clusterware.
Hover over a point on a graph to view detailed information.
Zoom in on the timeline.

Report

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

The report includes:

Summary Timeline
Observed Findings

Use the report to:

View event information as a subplot within the Summary Timeline Gantt chart.
Review top-ranked metrics associated with a detected problem in tabular format.
Examine metrics associated with a problem finding in graphical format.
Investigate the state of the system at a specific problematic point in time using Problematic Snapshots.

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:

Explore best practice compliance information in a visual format.
Filter best practice checks by status using the visualizations or the Status filter.
Search for checks across all sections of the best practice report.
Review the best practice report in a vertically organized view.
View the overall Health Score and the visual distribution of checks, including failed checks.

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:

Components on which the checks were performed
Best Practice Checks performed on each component
Status of each check

Use the available controls to explore and customize the report:

Click Settings to configure the information displayed in the report. A dialog opens with options and toggles that you can use to customize the report.
Click Show Details to open a side panel that explains the formula used to calculate the Health Score.
In the System Summary table, click the arrow in the Database Servers, Storage Servers, or RDMA Switches row to view additional information.
In the DB Homes row of the System Summary table, click the arrow to open a side panel that lists the database homes in the system.
Use the Jump to section list to navigate directly to a specific section of 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:

Use the filter section to search for specific values.
Select a time range to view system changes that occurred during a specific period.

Recommended Software

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:

Metrics
Alerts

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:

Disk controller battery charge
CPU utilization
CPU time used by the Management Server
File system space utilization

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:

Table
Graph

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

You can:

Click Expand All to display details for all alerts.
Click the arrow for an individual alert to view detailed information.

The Graph view categorizes alerts by:

Severity, such as Critical and Warning
Type, such as Stateful and Stateless

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:

RPM name
Version
Release
Architecture

Use the available controls to review and compare RPM information:

Enter an RPM name in the filter field to find specific RPMs.
The RPM Name, Version, Release, and Arch columns remain fixed while you navigate the RPM information.
Enable Show RPM Differences to display differences in RPMs across nodes.

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:

Normal - Displays normal Oracle Database parameters and is selected by default.
Hidden - Displays hidden Oracle Database parameters.

Use the available controls to review and compare database parameters:

Enter a parameter name in the filter field to find specific parameters.
The Parameter column remains fixed while you view parameter properties across multiple databases.
Enable Show different properties across databases to display parameters whose properties differ between databases.
Click Hidden to view hidden Oracle 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:

Enter a parameter name in the filter field to find specific parameters.
The Parameter column remains fixed while you view parameter properties across multiple hosts or nodes.
Enable Show different properties across nodes to display parameters whose properties differ between hosts or nodes.

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 - Displays patch information and patching history.
Components - Displays components and versions affected by applied patches.

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:

In the Timeline section, double-click a patch ID to view the host on which the patch was applied and when it was applied.
Enter a patch ID in the filter field to find and view details for a specific patch.
Click Show to open the Patch Analysis details in a side panel.
Click X to clear the current filter.

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 - Displays disk usage and available space across hosts.
Diagnostic Space Usage - Displays disk space consumed by diagnostic data.

Disk Utilization

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

Directory structure
Space consumed by directories
Space consumed by files
Available disk space

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:

Select a specific node.
Select the type of diagnostic data collected.
Review the disk space consumed by the selected diagnostic data.

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:

Generate an AHF Insights report:
```
ahf analysis create --type insights
```
Open the generated AHF Insights report.
Click Database Anomalies Advisor.
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:

Automatic Workload Repository (AWR) Reports
AWR Compare Reports
Performance Hub (PerfHub) 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:

Diagnose database performance bottlenecks.
Identify resource-intensive SQL statements.
Analyze CPU, memory, and I/O utilization.
Monitor database workload and usage trends.
Identify database wait events and other sources of latency.
Support database performance tuning and optimization.

Supported Systems and Platforms

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

Oracle Exadata
Oracle Database Appliance (ODA)
Oracle Real Application Clusters (Oracle RAC)
Oracle Database single-instance environments

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:

CPU, memory, and I/O utilization
Database wait events
SQL statements consuming significant resources
Instance activity and workload information
Object-level statistics, such as index usage and table scans

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:

Database wait events
CPU, memory, and I/O utilization
SQL performance
Database workload and activity

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

Software upgrades
Configuration changes
Patching
Application changes
Changes in workload

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:

CPU and memory utilization trends
SQL performance information
I/O metrics
Database wait information
System and workload bottlenecks

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.