Row Lock Contention Caused By Workflow Mailer (Doc ID 1530928.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

 Daily getting blocking sessions caused by module e::gsm:WFMLRSVC:10006:OutboundThread1

Target type=Database Instance
Host=XXXXXXX
Occurred At=Jan 24, 2013 7:19:35 AM EET
Message=Session 550 is blocking 2 other sessions
Metric=Blocking Session Count
Metric value=
Blocking Session ID=SID: 550 Serial#: 625
Severity=Warning
Acknowledged=No
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN
=======================

SQL> SELECT lpad('-->',DECODE(a.request,0,0,5),' ')||a.sid sess  , a.type   , b.event   , b.seconds_in_wait  , c.module  FROM gV$LOCK a, gv$session_wait b, gv$session c  WHERE a.id1 IN (SELECT id1 FROM gV$LOCK WHERE lmode = 0)  and a.sid=b.sid  and b.sid=c.sid  and b.seconds_in_wait > 300     ORDER BY id1,request;

SESS            TY EVENT                          SECONDS_IN_WAIT
--------------- -- ------------------------------ ---------------
MODULE
----------------------------------------------------------------
550             TX SQL*Net message from client               4552
e::gsm:WFMLRSVC:10006:OutboundThread1

 -->674        TX enq: TX - row lock contention             4309
Streams

SID    SERIAL# S_PID                    C_PID                    STATUS
---------- ---------- ------------------------ ------------------------ --------
TO_CHAR(S.LOGON_T
-----------------
      550        625 14221556                 12714206                 INACTIVE
23:01:13 07:01:12


      SID    SERIAL# S_PID                    C_PID                    STATUS
---------- ---------- ------------------------ ------------------------ --------
TO_CHAR(S.LOGON_T
-----------------
      674         53 12386418                 12386418                 ACTIVE
23:11:12 11:43:59

Cause

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