My Oracle Support Banner

Slow database performance as LMS was busy dumping block dump due to diag fix (Doc ID 2460427.1)

Last updated on OCTOBER 15, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

LMS tace file growing fast.Lots of CR events, leading to poor DB performance

Snap Id Snap Time Sessions Cursors/Session Instances
Begin Snap: 119534 06-Sep-18 12:00:13 524 35.1 3
End Snap: 119535 06-Sep-18 12:21:42 474 40.3 3
Elapsed: 21.48 (mins)
DB Time: 839.72 (mins)

Snap Id Snap Time Sessions Cursors/Session Instances
Begin Snap: 119493 05-Sep-18 16:30:05 1346 58.7 2
End Snap: 119494 05-Sep-18 17:00:20 1331 58.2 2
Elapsed: 30.25 (mins)
DB Time: 2,696.75 (mins)

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
gc current grant busy 436,533 31.5K 72.19 19.5 Cluster
DB CPU 20.2K 12.5
db file sequential read 2,013,542 19.1K 9.49 11.8 User I/O
gc cr block 2-way 1,401,383 16.7K 11.95 10.3 Cluster
gc current block 2-way 1,565,162 14.7K 9.37 9.1 Cluster
gc buffer busy acquire 138,866 10.4K 74.84 6.4 Cluster
enq: TX - index contention 44,621 9356 209.68 5.8 Concurrency

File_name:: awrrpt_1_119493_119494.html

Snap Id Snap Time Sessions Cursors/Session Instances
Begin Snap: 119493 05-Sep-18 16:30:06 1199 65.7 2
End Snap: 119494 05-Sep-18 17:00:20 1352 69.9 2
Elapsed: 30.24 (mins)
DB Time: 4,245.39 (mins)

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
gc current grant busy 568,734 40.3K 70.92 15.8 Cluster
db file sequential read 3,598,318 37.8K 10.49 14.8 User I/O
gc current block 2-way 1,535,154 31.9K 20.78 12.5 Cluster
gc cr block 2-way 1,362,814 30.9K 22.71 12.1 Cluster
DB CPU 26.5K 10.4
gc buffer busy acquire 201,763 16K 79.43 6.3 Cluster

File_name:: awrrpt_2_119493_119494.html

 

 

 

LMS trace files are growing with block dumps:

---------- xxx051_lms0_11234.trc --------------------------------------------

*** 2018-08-13 17:45:34.851
kcbz_exec_ckf: check function 0x10640eea0 returned error=10632:1
Suspect buffer header:
BH (0x41bc465c8) file#: 394 rdba: 0x62952457 (394/1385559) class: 1 ba:
0x419e9e000
set: 87 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 2 obj: 50066 objn: 50066 tsn: [0/15] afn: 394 hint: f
hash: [0x507c60558,0xb51a6e998] lru: [0x56fb28828,0x453b194e0]
ckptq: [NULL] fileq: [NULL]
objq: [0x56fb28850,0x50bba3eb0] objaq: [0x41fc35348,0x5cbcf18e0]
use: [NULL] wait: [NULL] fast-cr-pins: 1
st: XCURRENT md: NULL fpin: 'kduwh01: kdusru' fscn: 0x380.ed0dd464 tch: 1
le: 0x647f1cdf0
flags: block_written_once remote_transfered
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
buffer tsn: 15 rdba: 0x62952457 (394/1385559)
scn: 0x380.ed0dd46a seq: 0x01 flg: 0x06 tail: 0xd46a0601
frmt: 0x02 chkval: 0x15ed type: 0x06=trans data
Hex dump of block: st=0, typ_found=1

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
References


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