Bug 17052702 - LCK hang with 'enq: IV - contention'

(Doc ID 2410520.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

 LCK hang with 'enq: IV - contention'

alert log

Sat May 12 06:09:18 2018
Archived Log entry 105974 added for thread 2 sequence 46612 ID 0x48dd6d61 dest 1:
Sat May 12 06:40:06 2018
Auto-tuning: Starting background process GTX4
Starting background process GTX4
Sat May 12 06:40:06 2018
GTX4 started with pid=153, OS id=14294
Sat May 12 06:44:33 2018
LCK1 (ospid: 18642) waits for event 'row cache cleanup' for 79 secs.
LCK1 (ospid: 18642) waits for latch 'shared pool' for 79 secs.
Sat May 12 06:44:33 2018
LCK1 (ospid: 18642) is hung in an acceptable location (rowcache|latch-get 0x25.01).
Sat May 12 06:46:53 2018
LCK1 (ospid: 18642) waits for event 'libcache interrupt action by LCK' for 43 secs.
Sat May 12 06:46:53 2018
LCK1 (ospid: 18642) is hung in an acceptable location (libcache 0x41.02).
Sat May 12 06:50:10 2018
Auto-tuning: Shutting down background process GTX4
Sat May 12 06:51:33 2018
LCK1 (ospid: 18642) waits for event 'libcache interrupt action by LCK' for 323 secs.
Sat May 12 06:51:33 2018
LCK1 (ospid: 18642) is hung in an acceptable location (libcache 0x41.02).
Sat May 12 06:57:02 2018
Sat May 12 06:57:02 2018

...

Sat May 12 06:57:02 2018
WARNING: inbound connection timed out (ORA-3136)

...

Sat May 12 06:57:50 2018
WARNING: inbound connection timed out (ORA-3136)

...

Sat May 12 06:59:03 2018
WARNING: inbound connection timed out (ORA-3136)

 

diag process trace shows the following

----------------------------------------
SO: 0x75cb5a410, type: 2, owner: (nil), flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x75cb5a410, name=process, file=ksu.h LINE:13572, pg=0 conuid=0
(process) Oracle pid:20, ser:1, calls cur/top: 0x7612cb538/0x7612cb538
flags : (0x6) SYSTEM icon_uid:0
flags2: (0x0), flags3: (0x10)
intr error: 0, call error: 0, sess error: 0, txn error 0
intr queue: empty
ksudlp FALSE at location: 0
(post info) last post received: 0 0 26
last post received-location: ksa2.h LINE:290 ID:ksasnd
last process to post me: 0x758aa92a0 197 2
last post sent: 0 0 139
last post sent-location: kjc.h LINE:2086 ID:KJCS Post snd proxy to flush msg
last process posted by me: 0x75cb58150 1 6
(latch info) wait_event=0 bits=0x0
Process Group: DEFAULT, pseudo proc: 0x760c8aee0
O/S info: user: oracle, term: UNKNOWN, ospid: 18642 <---** LCK
OSD pid info:

...

Current Wait Stack:
1: waiting for 'enq: IV - contention'
type|mode=0x49560003, id1=0x53594e43, id2=0x28
wait_id=2344557420 seq_num=37723 snap_id=17
wait times: snap=2 min 46 sec, exc=13 min 2 sec, total=13 min 2 sec
wait times: max=infinite, heur=13 min 2 sec
wait counts: calls=1567 os=1567
in_wait=1 iflags=0x1522
0: waiting for 'libcache interrupt action by LCK'
location=0x1, =0x0, =0x0
wait_id=2344557379 seq_num=37690 snap_id=41
wait times: snap=0.000000 sec, exc=0.003843 sec, total=13 min 4 sec
wait times: max=infinite, heur=13 min 4 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x15a2
There are 127 sessions blocked by this session.

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms