@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“Oracle Autonomous Health Framework Problem and Solution Space”

Oracle Autonomous Health Framework Problem and Solution Space

Oracle Autonomous Health Framework (AHF) maximizes availability and performance by enforcing best practices, capturing data at first failure, monitoring the whole system (server, database, I/O, and network) to proactively discover issues and notify the user and provide timely bug resolution by suggesting fixes automatically after failure.

System administrators can use most of the components in Oracle Autonomous Health Framework interactively during installation, patching, and upgrading. Database administrators can use Oracle Autonomous Health Framework to diagnose operational runtime issues and mitigate the impact of these issues.

Availability Issues

Availability issues are runtime conditions that threaten the availability of the software stack.

These issues can originate from software components, such as Oracle Database, Oracle Grid Infrastructure, and the operating system, or from underlying hardware resources, such as CPU, memory, network, and storage.

Oracle Autonomous Health Framework (AHF) components help detect, diagnose, and resolve availability issues.

Server Availability Issues

Server availability issues can cause a server to be evicted from a cluster, resulting in the shutdown of database instances running on that server.

Examples include:

Database Availability Issues

Database availability issues can cause an Oracle Database or one of its instances to become unresponsive and unavailable to applications and users.

Examples include:

Performance Issues

Performance issues are runtime conditions that adversely affect system performance.

These issues can originate from:

Database server and client performance issues are often closely related. For troubleshooting purposes, they can be categorized according to whether they originate primarily from the database server or the database client.

Database Server Performance Issues

Examples include:

Performance Issues Caused by Database Clients

Examples include: