|
|
背景：
两个RAC集群（11.2.0.4）通过DBlink/goldengate进行数据传输过程中频繁报错：
ORA-00600: internal error code, arguments: [kjbrchkpkeywait:timeout], [32134], [37867], [4408119], [0], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_xxxxx/orcl1_ora_xxxxx_ixxxxx.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ORA-00600: internal error code, arguments: [kjbrchkpkeywait:timeout], [32134], [10676], [4313402], [0], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_xxxxx/orcl1_ora_xxxxx_ixxxxx.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
查看数据传输目标端的trace文件，出现大量gc current grant busy等待事件
Session Wait History:
elapsed time of 0.768579 sec since last wait
0: waited for 'gc current grant busy'
=0x44c, =0x30db80, =0x2010008
wait_id=473003 seq_num=14959 snap_id=1
wait times: snap=0.000513 sec, exc=0.000513 sec, total=0.000513 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.001454 sec of elapsed time
1: waited for 'db file sequential read'
file#=0x44d, block#=0x3005a3, blocks=0x1
wait_id=473002 seq_num=14958 snap_id=1
wait times: snap=0.001404 sec, exc=0.001404 sec, total=0.001404 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.000040 sec of elapsed time
2: waited for 'gc current grant 2-way'
=0x44d, =0x3005a3, =0x2000001
wait_id=473001 seq_num=14957 snap_id=1
wait times: snap=0.000336 sec, exc=0.000336 sec, total=0.000336 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.008477 sec of elapsed time
3: waited for 'gc current grant 2-way'
=0x30c, =0x293eff, =0x2000076
wait_id=473000 seq_num=14956 snap_id=1
wait times: snap=0.000378 sec, exc=0.000378 sec, total=0.000378 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.001488 sec of elapsed time
4: waited for 'gc current grant 2-way'
=0x30c, =0x293efe, =0x2000076
wait_id=472999 seq_num=14955 snap_id=1
wait times: snap=0.000360 sec, exc=0.000360 sec, total=0.000360 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.002189 sec of elapsed time
5: waited for 'gc current grant 2-way'
=0x30c, =0x293efd, =0x2000076
wait_id=472998 seq_num=14954 snap_id=1
wait times: snap=0.000319 sec, exc=0.000319 sec, total=0.000319 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.001104 sec of elapsed time
6: waited for 'gc current grant 2-way'
=0x30c, =0x293efc, =0x2000076
wait_id=472997 seq_num=14953 snap_id=1
wait times: snap=0.000405 sec, exc=0.000405 sec, total=0.000405 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.000171 sec of elapsed time
7: waited for 'gc current grant 2-way'
=0x30c, =0x293efb, =0x2000076
wait_id=472996 seq_num=14952 snap_id=1
wait times: snap=0.001336 sec, exc=0.001336 sec, total=0.001336 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.000412 sec of elapsed time
8: waited for 'gc current grant 2-way'
=0x30c, =0x293efa, =0x2000076
wait_id=472995 seq_num=14951 snap_id=1
wait times: snap=0.000285 sec, exc=0.000285 sec, total=0.000285 sec
wait times: max=infinite
wait counts: calls=1 os=1
occurred after 0.001814 sec of elapsed time
9: waited for 'gc current grant 2-way'
=0x30c, =0x293ef9, =0x2000076
wait_id=472994 seq_num=14950 snap_id=1
wait times: snap=0.000342 sec, exc=0.000342 sec, total=0.000342 sec
wait times: max=infinite
wait counts: calls=2 os=2
occurred after 0.000586 sec of elapsed time
Sampled Session History of session 3292 serial 29111
通过查询MOS文档，得到几个解决方案。
MOS文档截图如下：
我现在的方案是：
1. 怀疑是Oracle的bug，打算依照MOS文档打上对应补丁
2. 修改_gc_read_mostly_locking=FALSE
【麻烦老师帮忙看看这个问题，我的判断是否有误~~Thanks♪(･ω･)ﾉ】
|
|
发表于 2019-9-4 06:40:36
发表于 2019-9-5 07:57:31
