AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Provides a summary of cluster and cluster resources, and ASM details.

Cluster Summary

Figure 5-2 Cluster Summary

Provides a brief overview on System, Oracle Grid Infrastructure, Incident, Oracle Database, Database Server, Storage Server, and RDMA Network Fabric Switch.

• Click the arrow located inside the Database Home section to get Database Home details.
• Click Copy as text to copy the cluster summary into the clipboard.

Cluster Resources

Figure 5-3 Cluster Resources

Provides details on the cluster resources, Oracle Database, pluggable database (PDB), and listener, paginated. The details include CRS resource names, online or offline statuses of the targets, state of the resources, and the servers on which the resources are running.

• Click the Expand All toggle button to view details of all cluster resources.

ASM Details

Figure 5-4 ASM Details

Provides details on the nodes, instance names, online or offline statuses of the nodes, disk group names, online or offline statuses of the disk groups, and percentage of disk usage, paginated.

AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Figure 5-5 Databases

Provides basic and detailed information about Oracle Databases running on the system.

• Click Expand All to view detailed information on all items or click an arrow button to view detailed information on a specific item.

AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Figure 5-6 Database Servers

AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Figure 5-7 Storage Servers

AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Figure 5-8 Fabric Switches

AHF 24.10

In this release clicking an event on the Insights timeline opens the corresponding log entry within a new file viewer.

The AHF Insights timeline displays all significant database-related events in context. For more detailed analysis, you can now browse the associated log file using the new File Viewer. Clicking any log event in the Timeline opens the corresponding file at the event location.

Figure 5-9 Timeline

Once opened the full contents of the log file can be browsed and easily searched.

Figure 5-10 Insights File Viewer

To use the Insights Timeline, open any AHF diagnostic collection, extract the Insights report, and select the Timeline section from the home screen.

How does AHF Insights UI render this information

Figure 5-11 Timeline - Host Faceted View

Figure 5-12 Timeline - Event Faceted View

Provides Timeline visualization in a graph and provides a table with specific information about each timestamp.

• Search values using the filter section.
• Filter by a specific time range.
• Click the arrow located at the left side of a specific date to view detailed information regarding a specific timestamp.
• Hover over a specific data point in the graph to get detailed information about that specific point in time.
• Zoom into the timeline.

AHF 23.8

AHF 23.8 includes the following enhancements to the user interface to make it more intuitive and easier to use.

You can:

• Spot the disks that have anomalies. In the Operating System Issues tab, under Local IO, click Disk to view Disk Metrics. Disks that have anomalies are marked with an X mark.
• Explore process aggregate from operating system details in a more intuitive way.
  • Demarcated process aggregates per the instance group like Databases, ASM, APX (Apex), IOS, Clusterware, and so on.
  • Legends specific to individual category rather than single legend for all categories.

AHF 23.10

AHF 23.10 includes the following enhancements to the user interface to make it more intuitive.

You will now be able to view the data in problematic time ranges in plots with more data points.

The number of data points for plots under Operating System Issues section are dynamic for optimal time taken to generate report.

AHF 23.11

Starting in AHF 23.11, you will be able to view data coming from Exawatcher.

You can explore data coming from cell nodes in a visual format. You can switch between cell nodes, tagged as (S), and compute nodes, tagged as (D) from a dropdown. You will be able to examine Flash Disks, Flash Disk Aggregates, and Hard Disk Aggregates metrics.

How does AHF Insights UI render this information

Figure 5-13 Operating System Issues - Configuration

Figure 5-14 Operating System Issues - Metrics

Figure 5-15 Operating System Issues - Metrics - Disk Anamolies

Figure 5-16 Operating System Issues - Metrics - Process Aggregation

Figure 5-17 Operating System Issues - Metrics - Local I/O - Flash Disks

Figure 5-18 Operating System Issues - Metrics - Local I/O - Flash Disk Aggregation

Figure 5-19 Operating System Issues - Metrics - Local I/O - Hard Disk Aggregation

Figure 5-20 Operating System Issues - Report

Provides details about the metrics collected on the system and a detailed report on operating system anomalies. This page presents three views, Configuration, Metrics, and Report.

Metrics view has tabs displaying CPU, Memory, System I/O, Process, Network interface, Process aggregation metrics, and green and red icons indicating the statuses. From the drop-down list at the upper-right corner, select a node for which you want to view the metrics. Select a time range from the calendar widget to view metrics for that period.

Report view includes Summary Timeline and Observed Findings.

Configuration

This tab showcases CPU, Memory, IO, and Network configuration details of the systems from where operating system metrics were collected.

Metrics

System Overview

This tab showcases overview of resources such as CPU, memory, processes, and I/O operation.

• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

CPU Metrics

This tab showcases CPU metrics.

• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Memory Metrics

This tab showcases memory metrics.

• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Local I/O Metrics

This tab show case System IO metrics.

• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Process Metrics

This tab showcases process metrics.

• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Network Metrics

This tab showcases network interface metrics.

• Select different metrics related to network like interface, IP, UDP, and TCP.
• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Process Aggregation Metrics

This tab showcases aggregation of process metrics.

• Select a node from the Select Node drop-down list to view node-specific process aggregation metrics.
• Hover over a specific point in time of the graph to get detailed information.
• Zoom into the timeline.

Report

With Report view, explore the findings in a drop-down fashion with a full widescreen view.

AHF 23.8

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

AHF has thousands of Best Practice Compliance Checks, which are run automatically by AHF Oracle Orachk and Oracle Exachk. The results of these checks are viewable in HTML reports and output in JSON and XML for consumption into other tools. In addition, all Best Practice Compliance Checks are fully integrated into AHF Insights for running on-demand.

AHF Insights makes it easy to quickly see the Health Score, understand where systems are out of compliance and then take the necessary corrective action.

ahf analysis create --type insights

How does AHF Insights UI render this information

Figure 5-21 Best Practice Issues

Provides the results of Best Practices Compliance checks run on the system, paginated. The details include the list of Components on which the checks were run, the Best Practice Checks that were run on the components, and Statuses of those checks.

• Hover the mouse pointer over doughnut pie chart and stacked bar chart to view snippets in a tooltip.
• Filter the checks by severity - CRITICAL, FAIL, WARN, PASS, and INFO.
• Use the Component drop-down list to navigate to different sections of the report.
• Click the arrow on each entry in the table to view details of one specific issue.

How does AHF Insights UI render this information

Figure 5-22 System Change

Provides details on the changes applied to the system, paginated.

• Search values using the filter section.
• Filter by a specific time range.

AHF 23.8

Starting in AHF 23.8, you will be able copy data in text format into the clipboard to post it into SR body while raising a service request.

How does AHF Insights UI render this information

Figure 5-23 Recommended Software

Lists recommended software and links to supported versions.

How does AHF Insights UI render this information

Database Server includes two sections, Management Server Metrics and Alerts recorded in Management Server across Hardware , Software, and ADR.

Metrics

Figure 5-24 Database Server Metrics

Metrics section provdies details about the Management Server metrics such as Disk controller battery charge, CPU utilization, CPU time used by the Management Server, Total space utilized on the file system, and so on.

• From the drop-down list, select a host for which you want to view the metrics.

Alerts

Figure 5-25 Database Server Alerts

Alerts section provides details about the Alerts recorded in the Management Server across hardware, software, and ADR. Alert section has two views, Table and Graph.

Table view provides Alert Details such as description of the alert and the remedial action you can take, in tabular format.

• Click the Expand All toggle button to view details of all alerts.
• Click the arrow to view detailed information about an alert.

Graph view categorises the alerts by severity such as Critical and Warning, and type such as Stateful and Stateless.

• Click the Show open alerts toggle button to view the list of open alerts. The button is turned on by default.

How does AHF Insights UI render this information

Figure 5-26 List of RPMs

Lists RPMs and the differences between them across nodes, paginated.

• Enter the name of the parameter in the filter field to filter the RPMs.
• The RPM Name, Version, Release, and Arch columns remains fixed.
• Click the Show RPM differences toggle button to view the differences between the RPMs across nodes.

How does AHF Insights UI render this information

Figure 5-27 Oracle Database Parameters - Normal

Figure 5-28 Oracle Database Parameters - Hidden

Lists normal and hidden Oracle Database parameters, paginated. This page also provides two views, Normal and Hidden. Normal view is displayed by default.

• Enter the name of the parameter in the filter field to filter the parameters.
• The Parameter column remains fixed and you can view the properties of each parameter across multiple databases.
• Click the Show different properties across databases toggle button to view different properties across databases.
• Click Hidden to view the hidden parameter.

How does AHF Insights UI render this information

Figure 5-29 Kernel Parameters

Lists the kernel parameters, paginated.

• Enter the name of the parameter in the filter field to filter the parameters.
• The Parameter column remains fixed and you can view the properties of each parameter across multiple hosts/nodes.
• Click the Show different properties across hosts/nodes toggle button to view different properties across hosts/nodes.

How does AHF Insights UI render this information

Figure 5-30 Patch Information

Figure 5-31 Patch Information - Timeline

Figure 5-32 Patch Information - Components

Provides a list of patches to keep track of which patch was applied to which hosts, where (Oracle Database home or Grid home), and when (timeline). Gaps or inconsistencies in patching are highlighted across nodes for the same home. Lists bugs that a particular patch provides the fixes for. Bugs and relevant patch information can be quickly searched and viewed via interactive reports.

Patches tab:

• In the Timeline section, double-click a patch ID to view on which host and when the patch was applied.
• Enter the patch ID in the filter field to filter and view the patch details.
• Under Applied Date, click the right arrow key to view list of bugs that a particular patch addresses.
• Click the X mark to clear the filter.

Components tab: Provides a paginated list components and their version affected by applying the patches.

How does AHF Insights UI render this information

Figure 5-33 Disk Utilization

Figure 5-34 Diagnostic Space Usage

Disk Utilization tab: Provides a paginated view of host-wise directory structure, space consumed by directories and files, and available space.

Diagnostic Space Usage tab: Provides a paginated view of disk spave consumed by diagnostics. Use the drop-down lists to filter by nodes and diagnostics collected..

AWR Reports (Automatic Workload Repository)

AWR is a built-in Oracle feature that collects, processes, and stores database performance statistics. These statistics are used to generate a detailed report of the database's performance over a specified time frame.

AWR reports help in diagnosing performance bottlenecks, resource-intensive SQL queries, and identifying areas for optimization. They are valuable in tuning the database and ensuring it runs efficiently.

AWR Compare Reports

AWR Compare Reports allow users to compare database performance between two specific time periods, providing insights into how performance metrics have changed over time.

These reports are particularly useful for identifying the impact of a system event, such as an upgrade or configuration change, and comparing performance under different workloads.

PerfHub Reports

PerfHub is part of Oracle Cloud (Autonomous Database) and provides an interactive, graphical interface for real-time performance diagnostics. It allows users to visualize performance data through a dashboard, offering a modern approach to performance reporting.

Figure 5-38 Performance Hub Reports

PerfHub reports are especially beneficial in cloud environments, providing real-time insights and helping administrators quickly pinpoint performance issues and bottlenecks.