'enq: FU - contention' and ORA-32701 Warning Seen in Alert Log
(Doc ID 1464844.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Alert log reports:
ORA-32701: Possible hangs up to hang ID=0 detected ...
DIA0 terminating blocker (ospid: 13202 sid: 2864 ser#: 12933) of hang with ID = 17
requested by master DIA0 process on instance 1
Hang Resolution Reason: Although the number of affected sessions did not
justify automatic hang resolution initially, this previously ignored
hang was automatically resolved.
by terminating session sid: 2864 ospid: 13202
The generated incident trace file will contain information somewhat similar to the following:
----- ------ ----- --------- ----- -----
1 1006 30561 411 M000 enq: FU - contention
3 2864 12933 13202 M001 not in wait
This shows that a M00* process is blocking another M00* process.
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