Oracle Autonomous Health Framework (AHF) helps maximize application resilience, performance, and security through AI-driven proactive issue prevention and resolution
It's the same technology Oracle uses in the cloud to keep the Autonomous Database running, and it's available for you at no extra cost as part of your existing software support agreement.
Autonomous Health Framework 24.9 is released and available to download
A new Performance Reports section has been added to AHF Insights, which includes PerfHub, AWR and AWR Compare reports.
AHF captures diagnostic data required for performance tuning in the dbperf SRDC via the command:
tfactl diagcollect -srdc dbperf -database db_name
AHF now embeds the most useful performance tuning reports, directly within the AHF Insights report.
A new Performance Reports section has been created, which contains:
Open the PerfHub report.
To make use of the new Performance Reports section:
tfactl diagcollect -srdc dbperf -database db_name
For more information on how to use the resulting performance reports see database performance tuning.
AHF now automatically detects new causes of node eviction, instance eviction and database slow performance, showing summary of the problem, cause and resolution in Insights.
Since version 24.4 AHF has had the ability to detect problems and show a summary with the resolution. The Problem Summary page is available under the Detected Problems panel in Insights.
This release adds the ability to automatically detect the following new problems:
To generate a diagnostic collection run tfactl diagcollect
then follow the prompts to select the issue of interest.
Transfer the resulting zip to a machine with a browser, open the Insights report and view the Detected Problems.
See the user guide for more information on resolving problems AHF has detected.
When using Oracle Data Guard, calculating switchover and failover readiness can be complicated and ensuring symmetry of config is critical.
In 24.5 AHF introduced the Data Guard health report in Insights. This functionality has now been redesigned and expanded, and is accessible from the Data Guard panel.
A new Configuration page has been added, which includes:
The lags and apply rate can be used to help identify any problems that exist with the redo transport services and the log apply services, and they can also help to determine whether or not the standby database is able to keep up with the primary database.
Clicking on the details button shows the Database Symmetry page, which enables comparison between primary and standby and also shows a list of Database Wait Events, with the corresponding time spent waiting. This can be used to pin-point performance bottlenecks.
Database Wait Events and Log Switches are local to the system where the Insights report is generated, to view a complete picture create Insights reports on both Primary and Standby.
To create an Insights report with Data Guard run the command:
ahf analysis create --type insights
For see the user guide for more information on AHF Insights
AHF can now monitor databases using a configured username and password instead of as SYSDBA.
AHF provides monitoring and alerting of databases anomalies. Previously AHF would perform this monitoring by connecting to the database as SYSDBA using OS authentication. However, this was not possible if OS authentication was disabled.
On Oracle Databases of 19.0.0.0.0 and above, AHF can now monitor the database using a configured username and password. This eliminates the dependency on OS authentication and reduces generation of audit records.
If you have already configured a user and password for use by AHF, this will be used.
To configure AHF to use a specific username and password use:
ahfctl setpassword
See the User Guide for more information on configuring database monitoring
AHF now includes Database Security Assessment (DBSAT) version 3.1 recommendations in best practice recommendations shown in Orachk and Exachk reports.
Oracle Database Security Assessment Tool (DBSAT) provides prioritized recommendations on how to mitigate identified security risks or gaps within Oracle Databases. DBSAT profiles the security and compliance posture of databases by evaluating the current state, including configuration, discovering sensitive data, and more.
AHF includes DBSAT recommendations within Orachk and Exachk reports. This makes it easy to get all cluster best practice recommendations including security in a single report without any separate downloads or installs.
As of AHF 24.9, the DBSAT version included has been upgraded to DBSAT 3.1.
To generate an AHF best practice report including security recommendations run:
ahfctl compliance -profile security
To generate an AHF best practice report including security recommendations as well as complete health of the system run:
ahfctl compliance -includeprofile security
View the user guide to learn more about AHF best practice checks.
24.9 includes the following new best practice checks for both Orachk and Exachk:
Then this new check is included for just Orachk:
All checks can be explored in more detail via the Health Check Catalogs:
Read more about best practice compliance checking with Exachk and Orachk.
AHF has upgraded the versions of third-party software libraries to fix Common Vulnerabilities and Exposures (CVEs).
AHF 24.9 has upgraded the versions of many third-party libraries. The following third-party libraries are upgraded due to CVEs:
See the user guide for more information on third party usage.
AHF releases a new version every month, here are recent new features by release:
To get started today download Oracle Autonomous Health Framework.
Gareth is Senior Principal Development Operations Manager for Oracle Autonomous Health Framework.
Previous Post
Next Post