My Oracle Support Banner

诊断补丁导致LMS忙于打印block dump而引发的数据库性能变慢 (Doc ID 2610726.1)

Last updated on NOVEMBER 24, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.1.0.2 和更高版本
本文档所含信息适用于所有平台

症状

LMS trace文件快速增长。数据库出现很多CR等待,导致数据库性能变差。

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文件增长,内容是block dump:

---------- 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

更改

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.