Huge LMS Trace With "KCL: A59: no lock elements" and "GLOBAL CACHE ELEMENT DUMP" (Doc ID 2142462.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

LMS trace is huge and growing quickly with the following: 

GLOBAL CACHE ELEMENT DUMP (address: 0xb604f5e88):
id1: 0x24d4 id2: 0x35 pkey: OBJ#0,53,153782 block: (53/9428)
lock: C rls: 0x0 acq: 0x1 latch: 6 lms: 0
flags: 0x31 fair: 0 recovery: 0
bscn: 0x31.911dff25 bctx: 0x0 scan: 0x0
lcp: 0x0 lnk: [NULL] lch: [NULL]
seq: 21 hist: 407 197 48 121 225 60 65 58 58 58 58 58 225 60 65 239
143:0 85
KCL: A59: no lock elements
cache size 21415
le locks 17251
imc locks 0
flash locks 0
latch 0
latch 1
latch 2
latch 3
latch 4
latch 5
latch 6
latch 7
latch 8
latch 9
latch 10
latch 11
latch 12
latch 13
latch 14
latch 15
granules inuse 2
granule 0 buffers 7560 lock elements 8190
GLOBAL CACHE ELEMENT DUMP (address: 0x884005168):
id1: 0x30ef id2: 0x2 pkey: OBJ#0,1,7700 block: (2/12527)
lock: S rls: 0x0 acq: 0x0 latch: 8 lms: 1
flags: 0x20 fair: 0 recovery: 0
bscn: 0x0.0 bctx: 0x0 scan: 0x0
lcp: 0x0 lnk: [NULL] lch: [0xb602ba590,0xb602ba590]
seq: 8 hist: 227 144:0 213 7 144:5 192 352 32 225 60 65 197 48 121 225 60
LIST OF BUFFERS LINKED TO THIS GLOBAL CACHE ELEMENT:
flg: 0x8080000 state: SCURRENT tsn: [0/1] tsh: 1
fpin: 'kdswh11: kdst_fetch' fscn: 0x31.913e186a
addr: 0xb602ba450 obj: 7700 cls: DATA
bscn: 0x31.77c27ba3 seq: 1 bflg: 0x6
GLOBAL CACHE ELEMENT DUMP (address: 0x884005280):

 

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