适用范围

Oracle 11G

问题概述

1、数据库频繁出现异常HANG现象，每次持续时间较短，均自动恢复正常。 2、查看Alert日志发现存在ORA-00600[KGL-heap-size-exceeded]等错误信息。

问题分析

查看近期数据库Alert日志及其它数据库日志

Alert日志信息：

2024-05-23T15:50:32.878605+08:00
Memory Notification: Library Cache Object loaded into SGA
Heap size 512000K exceeds notification threshold (51200K)
Details in trace file /u01/app/oracle/diag/rdbms/xxx/xxx2/trace/xxx2_ora_18908.trc
2024-05-23T15:50:32.878673+08:00
KGL object name :
WITH TD AS (
	SELECT
... ...
Errors in file /u01/app/oracle/diag/rdbms/xxx/xxx2/trace/xxx2_ora_18908.trc  (incident=474157):
ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], [0x6D4EC6BB0], [0], [524288024], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/xxx/xxx2/incident/incdir_474157/xxx2_ora_18908_i474157.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-05-23T15:51:33.624295+08:00
PMON failed to acquire latch, see PMON dump
2024-05-23T15:51:47.723467+08:00
DBRM (ospid: 18273) waits for event 'latch: shared pool' for 72 secs.
DBRM (ospid: 18273) waits for latch 'shared pool' for 72 secs.
2024-05-23T15:52:33.673582+08:00
PMON failed to acquire latch, see PMON dump
2024-05-23T15:52:46.719719+08:00
LCK1 (ospid: 18305) waits for event 'libcache interrupt action by LCK' for 97 secs.
LCK1 (ospid: 18305) waits for latch 'shared pool' for 97 secs.
2024-05-23T15:52:46.719842+08:00
LCK1 (ospid: 18305) is hung in an acceptable location (libcache|latch-get 0x45.02).
Errors in file /u01/app/oracle/diag/rdbms/xxx/xxx2/trace/xxx2_lmhb_18303.trc  (incident=494962):