ORA 600 KGL heap size exceeded - cheeyoung/sqlplus-public GitHub Wiki
Example 1
Memory Notification: Library Cache Object loaded into SGA
Heap size 1007188K exceeds notification threshold (97656K)
...
ORA-600 [KGL-heap-size-exceeded] [0x3F77F02D0] [6] [1031361160]
|
|
|
3rd |
1,031,361,160 |
1,007,188.6328125K |
1 Tue Mar 06 19:32:35 2018
2 Starting ORACLE instance (normal) (OS id: 4704)
...
559 ===========================================================
560 Tue Mar 06 19:34:26 2018
561 AUTO SGA: Could not access 5, shared pool advisor.
562 AUTO SGA: Disabling background sga auto-tuning.
563 Tue Mar 06 19:34:29 2018
564 Memory Notification: Library Cache Object loaded into SGA
565 Heap size 1007188K exceeds notification threshold (97656K)
566 Details in trace file /.../.../diag/rdbms/.../.../trace/..._ora_5114.trc
567 Tue Mar 06 19:34:29 2018
568 KGL object name :explain plan for
569 WITH WEEK_DATA AS(
...
576
577 Errors in file /.../.../diag/rdbms/.../.../trace/..._ora_5114.trc (incident=449):
578 ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], [0x3F77F02D0],
[6], [1031361160], [], [], [], [], [], [], [], []
579 Incident details in: /.../.../diag/rdbms/.../.../incident/incdir_449/..._ora_5114_i449.trc
...