My Oracle Support Banner

'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 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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:

 inst# SessId  Ser#     OSPID PrcNm Event
 ----- ------ ----- --------- ----- -----
     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.

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
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.