联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
alert日志报错
2021-04-19T15:06:08.208159+08:00
Memory Notification: Library Cache Object loaded into SGA
Heap size 512000K exceeds notification threshold (51200K)
Details in trace file /mnt/app/diag/rdbms/xff/xff/trace/xff_ora_12300.trc
2021-04-19T15:06:08.208212+08:00
KGL object name :select DISTINCT(BEGIN_TIME) beginTime,
MILE mile,
END_TIME endTime,
LAST_TIME lastTime,
BEGIN_TIME beginTime2,
END_TIME endTime2,
TEMPERATURE1 temperature1,
TEMPERATURE2 temperature2,
TEMPERATURE3 temperature3,
TEMPERATURE4 temperature4,
LATITUDE latitude,
LONGITUDE longitude
from T_XIFENFEI
where VEHICLE_ID = :1
and END_TIME is not null
and BEGIN_TIME BETWEEN TO_DATE(:2 , 'yyyy-MM-dd hh24:mi:ss') and TO_DATE(:3 , 'yyyy-MM-dd hh24
Errors in file /mnt/app/diag/rdbms/xff/xff/trace/xff_ora_12300.trc (incident=162089):
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded],
[0x1C4782708], [0], [524288008], [], [], [], [], [], [], [], []
Incident details in: /mnt/app/diag/rdbms/xff/xff/incident/incdir_162089/xff_ora_12300_i162089.trc
Use ADRCI or Support Workbench to package the incident.
数据库版本信息
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125 ORACLE_HOME: /mnt/app/product/12.2.0/dbhome_1 System name: Linux Node name: izbp1399kdj96ra6bjtwyxz Release: 3.10.0-693.2.2.el7.x86_64 Version: #1 SMP Tue Sep 12 22:26:13 UTC 2017 Machine: x86_64
Call Stack信息
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+119 call kgdsdst() 7FFD6CB9A258 000000002
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 000000082 ?
dbkedDefDump()+1200 call ksedst() 000000000 000000002 ?
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
ksedmp()+259 call dbkedDefDump() 000000003 000000002
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgexPhaseII()+2130 call ksedmp() 0000003EB 000000002 ?
7FFD6CB7BCC0 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgexExplicitEndInc call dbgexPhaseII() 7F4853DB46C0 7F4853DB77A0
()+602 7FFD6CB9E388 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
dbgeEndDDEInvocatio call dbgexExplicitEndInc 7F4853DB46C0 7F4853DB77A0
nImpl()+658 () 7FFD6CB9E388 ? 7FFD6CB7BDD8 ?
000000000 ? 000000082 ?
kglLargeHeapWarning call dbgeEndDDEInvocatio 7F4853DB46C0 7F4853DB77A0
()+1544 nImpl() 7F4853DF49A0 7FFD6CB7BDD8 ?
7F4853DF49A0 000000082 ?
kglHeapAllocCbk()+2 call kglLargeHeapWarning 7F4853DF49A0 ? 1C4782708 ?
27 () 000000000 01F400060 ?
0B6DADD88 000000082 ?
kghalp()+1086 call kglHeapAllocCbk() 7F4853DF49A0 ? 1C4782708 ?
2EE171B70 01F400060 ?
000000058 ? 000000082 ?
kkocsRegBindEqvCtxC call kghalp() 7F4853DF49A0 ? 0B6DADD88 ?
ommon()+145 2EE171B70 ? 000000001 ?
000000058 ? 0119E7860 ?
kkocsAddBeElem()+81 call kkocsRegBindEqvCtxC 7F4853DF49A0 ? 7FFD6CB9F460 ?
1 ommon() 2EE171B70 ? 000000001 ?
000000002 ? 0119E7860 ?
kkocsProcBSensPredC call kkocsAddBeElem() 7F484E2EF998 ? 7F484E2EFAC8 ?
B()+431 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
qksopVisitPreds()+5 call kkocsProcBSensPredC 7F484E2EF998 ? 7FFD6CB9F640 ?
39 B() 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkocsBuildBESelCtx( call qksopVisitPreds() 7F484E2EF998 ? 7FFD6CB9F640 ?
)+153 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkocsBindSensCheck( call kkocsBuildBESelCtx( 7F484E2EF998 ? 7FFD6CB9F640 ?
)+585 ) 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkoipt()+901 call kkocsBindSensCheck( 7F484E2EFA20 ? 7FFD6CB9F640 ?
) 0BBED4798 ? 209DFEA60 ?
000000002 ? 0119E7860 ?
kkoqbc()+4677 call kkoipt() 7F484E31F1E0 ? 7FFD6CB9F640 ?
0BBED4798 ? 209DFEA60 ?
000000002 ? 000000000
apakkoqb()+183 call kkoqbc() 7F484E31F1E0 ? 7F4853CC2958 ?
0BBED4798 ? 209DFEA60 ?
000000001 000000000 ?
apaqbdDescendents() call apakkoqb() 7FFD6CBA1870 ? 000000EB5 ?
+503 0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
apaqbd()+136 call apaqbdDescendents() 7FFD6CBA1870 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
apadrv()+1228 call apaqbd() 7FFD6CBA1870 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
opitca()+2139 call apadrv() 0BBED4C18 ? 7F4853CC2958 ?
0BBED4C18 ? 209DFEA60 ?
000000001 ? 000000000 ?
kksFullTypeCheck()+ call opitca() 7F484E2F2A08 0BBED4C18
86 7FFD6CBA42F0 209DFEA60 ?
000000001 ? 000000000 ?
rpiswu2()+627 call kksFullTypeCheck() 7FFD6CBA2FF8 ? 0BBED4C18 ?
7FFD6CBA42F0 ? 209DFEA60 ?
000000001 ? 000000000 ?
kksLoadChild()+8003 call rpiswu2() 7FFD6CBA2FF8 ? 0BBED4C18 ?
7FFD6CBA42F0 ? 209DFEA60 ?
7FFD6CBA24F8 ? 00000006A ?
kxsGetRuntimeLock() call kksLoadChild() 7F4853DF49A0 0BBED4C18 ?
+2029 7FFD6CBA42F0 ? 209DFEA60 ?
7FFD6CBA24F8 ? 00000006A ?
kksfbc()+15091 call kxsGetRuntimeLock() 7F4853DF49A0 7F484E2F2A08
7FFD6CBA4270 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708
opiexe()+2932 call kksfbc() 7F484E2F2A08 7F484E2F2A08 ?
7FFD6CBA4270 ? 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
kpoal8()+2679 call opiexe() 000000049 7F484E2F2A08 ?
7FFD6CBA58F0 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
opiodr()+1229 call kpoal8() 00000005E 000000026
7FFD6CBA9300 209DFEA60 ?
7FFD6CBA24F8 ? 1C4782708 ?
ttcpip()+1257 call opiodr() 00000005E 000000026
7FFD6CBA9300 000000000
7FFD6CBA24F8 ? 1C4782708 ?
opitsk()+1940 call ttcpip() 7F4853E11750 ? 000000026 ?
7FFD6CBA9300 00000017D ?
7FFD6CBA8D50 7FFD6CBA955C
opiino()+941 call opitsk() 000000000 000000000
7FFD6CBA9300 ? 00000017D ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opiodr()+1229 call opiino() 00000003C 000000004
7FFD6CBAAA18 00000017D ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opidrv()+1021 call opiodr() 00000003C 000000004
7FFD6CBAAA18 000000000
7FFD6CBA8D50 ? 7FFD6CBA955C ?
sou2o()+145 call opidrv() 00000003C 000000004
7FFD6CBAAA18 000000000 ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
opimai_real()+455 call sou2o() 7FFD6CBAA9F0 00000003C
000000004 7FFD6CBAAA18
7FFD6CBA8D50 ? 7FFD6CBA955C ?
ssthrdmain()+417 call opimai_real() 000000000 7FFD6CBAAD00
000000004 ? 7FFD6CBAAA18 ?
7FFD6CBA8D50 ? 7FFD6CBA955C ?
main()+262 call ssthrdmain() 000000000 000000002
7FFD6CBAAD00 000000001
000000000 7FFD6CBA955C ?
__libc_start_main() call main() 000000000 7FFD6CBAAF38
+245 7FFD6CBAAD00 ? 000000001 ?
000000000 ? 7FFD6CBA955C ?
_start()+41 call __libc_start_main() 000D04D40 000000002
7FFD6CBAAF38 7F484F241555 ?
000000000 ? 7FFD6CBA955C ?
--------------------- Binary Stack Dump ---------------------
根据官方描述,该问题是由于Bug 20917487 – CORRUPT KKOCS STRUCTURES AFTER PARTIAL PURGE OF CURSOR HEAP引起
解决方案：
1. 升级数据库到19.1+版本
2. 应用 Patch 20917487
3. Disable adaptive cursor sharing
alter system set "_optimizer_adaptive_cursor_sharing" = false; alter system set "_optimizer_extended_cursor_sharing_rel" = "none";
4. 通过隐含参数设置一个足够大的值
alter system set "_kgl_large_heap_warning_threshold"=83886080 scope=spfile; --一个足够大的值 --or alter system set "_kgl_large_heap_warning_threshold"=0 scope=spfile; alter system set "_kgl_large_heap_assert_threshold"=0 scope=spfile; shutdown immediate startup
参考文档：
ORA-600 [KGL-heap-size-exceeded] Errors in the Alert Log (Doc ID 2628072.1)
Memory Notification: Library Cache Object loaded into SGA / ORA-600 [KGL-heap-size-exceeded] (Doc ID 330239.1)