ORA-32701 with Hang Signature having 'enq: WF - contention' and 'not in wait' Event (Doc ID 2501396.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• Repeated entry of ORA-32701 logged inside database instance alert log
• alert_ORCL1.log inside <oracle base>/diag/rdbms/<db name>/<sid name>/trace location:
  
  DIA0 terminating blocker (ospid: 19195 sid: 11147 ser#: 36225) of hang with ID = 285
  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:11147 with serial # 36225 (ospid:19195)
  DIA0 successfully terminated session sid:11147 with serial # 36225 (ospid:19195) with status 31.
  DIA0 successfully resolved a GLOBAL, HIGH confidence hang with ID=285.
   
• ORCL1_dia0_15483_i4096107.trc inside <oracle base>/diag/rdbms/<db name>/<sid name>/incident/incdir_4096107 location:

  *** 2018-12-07 04:54:39.081
  Resolvable Hangs in the System
  Root Chain Total Hang
  Hang Hang Inst Root #hung #hung Hang Hang Resolution
  ID Type Status Num Sess Sess Sess Conf Span Action
  ----- ---- -------- ---- ----- ----- ----- ------ ------ -------------------
  285 HANG RSLNPEND 1 11147 2 3 HIGH GLOBAL Terminate Process
  Hang Resolution Reason: Although the number of affected sessions did not
  justify automatic hang resolution initially, this previously ignored
  hang was automatically resolved.
  Previous SESSION termination was unsuccessful. PROCESS termination
  will be attempted.

  Inst Sess Ser Proc Wait
  Num ID Num OSPID Name Event
  ----- ------ ----- --------- ----- -----
  3 4825 15140 24468 M002 enq: WF - contention
  1 11147 36225 19195 M000 not in wait

  The incident file on instance 1 may contain information
  about session 11147 with serial number 36225 and operating system
  process ID 19195. The incident file may contain a short stack
  and a process state dump.

   

Cause

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