AHF Insights Supported Platforms

AHF Insights is available with a standard AHF installation on supported Oracle Linux platforms. It is not available with a standalone AHF installation.

Supported Platforms

Installation or Environment TypeSupported
Standard AHF InstallationYes
Standalone AHF InstallationNo
Oracle Linux (OEL)Yes
Linux for ARMNo
zLinux (64-bit)No
Microsoft Windows 64-bitNo
Oracle Solaris x86-64No
HP-UX / AIXNo

Insights in Diagnostic Collections

All non-SRDC collections include AHF Insights when autoInsights is enabled.

Insights for SRDC collections also require autoInsights to be enabled.

When autoInsights is enabled, the following SRDCs and error events can trigger an Insights report.

Supported SRDCs and Error Events

dbhang

Oracle Database hang issues.

The following event can trigger an Insights report:

  • HANGING_SESSIONS (auto SRDC only)

dbinstancecrash

Oracle Database instance crash-related issues.

dbunixresources

Oracle Database issues related to operating system resources.

crsdbhangperf

Oracle Clusterware and Oracle Database performance issues.

dbhangperflite

Oracle Database performance and hang issues.

The following events can trigger an Insights report:

  • CHA_REDODG_HANG
  • CHA_CFENQ_HANG
  • CHA_CURSOR_PIN_S_W_X
  • ORA-32701 - Blocker Resolver detected one or more blocking scenarios.
  • ORA-32703 - Oracle sessions waiting for resources were deadlocked.
  • ORA-32704 - Oracle sessions or processes using Global Enqueue Service were deadlocked waiting for resources.
  • DIA0-HM-CRITICAL-ROOT
  • DIA0-HM-CRITICAL-PROCESS-BLOCKED

dbperf

Oracle Database performance issues.

dbrac

Oracle RAC data collection for Oracle Clusterware and Oracle ASM issues.

dbracperf

Oracle RAC performance issues.

exadata

Oracle Exadata critical issues.

The following event can trigger an Insights report:

  • ORA-29770 - The specified process made no progress within the maximum allowed time.

dbdataguard

Oracle Data Guard issues, including Data Guard Broker.

The following events can trigger an Insights report:

  • ORA-00600 (auto SRDC only, and args=3020) - Generic internal error number for Oracle program exceptions. It indicates that a process encountered a low-level, unexpected condition.
  • ORA-00752 (auto SRDC only) - A data block write to storage was lost during normal database operation on the primary database.

maareview

For maareview, the Insights report can include:

  • Exachk results for the database under review
  • AWR reports from normal and peak periods
  • Exawatcher data from normal and peak periods
  • System capacity planning insights
  • AHF Insights information, including Data Guard (DG) and Active Data Guard (ADG) configurations and metrics

crsasm

Oracle ASM and Clusterware-related issues.

The following events can trigger an Insights report:

  • ORA-01578 - Data block corruption caused by physical or media corruption.
  • ORA-04020 - Deadlock detected while attempting to lock an object.
  • ORA-04021 - Timeout occurred while waiting to lock an object.
  • ORA-04030 - Operating system memory was exhausted or a per-process limit on private memory usage was reached.
  • ORA-04031 - More shared memory was required than was available.
  • ORA-07445 - An operating system exception occurred that can result in the creation of a core file.