Slow database performance as LMS was busy dumping block dump due to diag fix
(Doc ID 2460427.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |