Row Lock Contention Caused By Workflow Mailer
(Doc ID 1530928.1)
Last updated on AUGUST 11, 2022
Applies to:
Oracle Workflow - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
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
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 |