Home

Description

Starting with Oracle Database 23AI, the DBMS_HANG_MANAGER package and its associated subprograms are desupported. This package was traditionally used to detect and manage session or system hangs, but Oracle now recommends relying on automated diagnostic tools and health checks built into the database infrastructure.

Manual hang management using DBMS_HANG_MANAGER procedures such as SUSPEND_SESSION or RESUME_SESSION will no longer function in Oracle 21c and future versions. Instead, use DBMS_HM (Health Monitor) and Oracle's Automatic Diagnostic Repository (ADR) to handle session or system health issues.

Key Benefits

• Modern Diagnostics: Enables the use of advanced, automated diagnostic tools, reducing manual intervention.
• Improved Stability: Minimizes risk of human error in system hang scenarios through automated detection and resolution mechanisms.
• Future Compatibility: Ensures applications remain compliant with Oracle 21c and later database versions without relying on deprecated packages.

Non-compliant Code Example

BEGIN
  DBMS_HANG_MANAGER.SUSPEND_SESSION(session_id => 123);         --Non compliant code (DBMS_HANG_MANAGER package desupported)
END;