My Oracle Support Banner

Excessive Hang Manager warning messages in LMHB trace file (Doc ID 2729174.1)

Last updated on OCTOBER 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Excessive Hang Manager warning messages reported in LMHB trace file every 2 seconds:

$ tail -50 /u01/app/oracle/diag/rdbms/<db>/<instance>/trace/<instance>_lmhb_25363.trc

*** 2020-09-18T13:43:53.013005+02:00
Hang Manager: Health: System:33, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:43:55.115821+02:00
Hang Manager: Health: System:20, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:43:57.069112+02:00
Hang Manager: Health: System:33, Cluster:30. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:43:59.021860+02:00
Hang Manager: Health: System:33, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:44:01.124727+02:00
Hang Manager: Health: System:20, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:44:03.077790+02:00
Hang Manager: Health: System:42, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:44:05.030736+02:00
Hang Manager: Health: System:33, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

*** 2020-09-18T13:44:07.133862+02:00
Hang Manager: Health: System:33, Cluster:36. Hangs: Local:0, Global:0
Hang Manager: Current no of hangs 4, no of impacted sessions - hangs:0 deadlocks:0

Changes

System might be experiencing degraded performance at the time.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.