5.1 Introduction to AHF Insights

AHF Insights provides a bird's eye view of the entire system with the ability to further drill down for root cause analysis.

Note:

Starting in AHF 23.8, plotly.js dependency on CDN has been removed for customers using AHF Insights in restrictive environments.

Previously, results from different AHF components were not available in a single dashboard making it challenging to combine and correlate. To mitigate this, AHF Insights provides a web-based graphical user interface, which does not require a web server to host the web pages, for all diagnostic data collectors and analyzers that are part of AHF Kit.

AHF performs a contextual diagnostic collection for a given period to analyze the performance of database systems. The collection includes diagnostic data from various AHF features such as:
  • Configuration
  • Environment Topology
  • Metrics
  • Logs
This diagnostic data collected from the system passes through AHF Insights, which in turn produces an offline report with analysis in the following areas:
  • System Configuration
  • System State
  • Anomalies in the Operating System
  • Best Practices Compliance
  • System Traces
  • Root cause for issues and fixes in some of the anomalous cases
To get started, run the following command:
ahf analysis create --type insights

Example 5-1 ahf analysis create --type insights

[root@node02 ~]# tfactl print status

.-----------------------------------------------------------------------------------------------.
| Host   | Status of TFA | PID    | Port | Version    | Build ID             | Inventory Status |
+----------------+---------------+--------+------+------------+----------------------+----------+
| node02 | RUNNING       | 134679 | 5000 | 22.3.0.0.0 | 22300020221031131221 | COMPLETE         |
| node01 | RUNNING       | 128438 | 5000 | 22.3.0.0.0 | 22300020221031131221 | COMPLETE         |
'----------------+---------------+--------+------+------------+----------------------+----------'
[root@node02 ~]# ahf analysis create --type insights --last 2h
Starting analysis and collecting data for insights
Collecting data for AHF Insights (This may take a few minutes per node)
AHF Insights report is being generated for the last 2h
From Date : 11/20/2022 01:16:41 UTC - To Date : 11/20/2022 03:17:15 UTC
Report is generated at : /opt/oracle.ahf/data/repository/collection_Sun_Nov_20_03_16_36_UTC_2022_node_all/node2_insights_2022_11_20_03_18_13.zip

Transfer the diagnostic zip file from the machine where the collection was initiated to a machine with a web browser. Unzip the file, then locate and open the index.html file.