11g突然宕机，报 ORA 7445 [kgh_get_shrinkable_grancnt

郑全

1月29日，15：24 ，出现xxx系统数据库突然自动停止

停库日志如下：

Mon Jan 29 15:24:37 2024
Dumping diagnostic data in directory=[cdmp_20240129152437], requested by (instance=1, osid=3182), summary=[incident=397951].
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7F15515B2F70] [PC:0x2C34D46, kgh_get_shrinkable_grancnt()+136] [flags: 0x0, count: 1]
Mon Jan 29 15:24:39 2024
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x38] [PC:0x97DA058, kghfre()+126] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/emr/emr/trace/emr_ora_8108.trc  (incident=405502):
ORA-07445: 出现异常错误: 核心转储 [kgh_get_shrinkable_grancnt()+136] [SIGSEGV] [ADDR:0x7F15515B2F70] [PC:0x2C34D46] [Address not mapped to object] []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/emr/emr/trace/emr_pmon_10837.trc  (incident=368126):
ORA-07445: exception encountered: core dump [kghfre()+126] [SIGSEGV] [ADDR:0x38] [PC:0x97DA058] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/emr/emr/incident/incdir_368126/emr_pmon_10837_i368126.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/emr/emr/trace/emr_pmon_10837.trc:
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghfre()+126] [SIGSEGV] [ADDR:0x38] [PC:0x97DA058] [Address not mapped to object] []
PMON (ospid: 10837): terminating the instance due to error 602
System state dump requested by (instance=1, osid=10837 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/emr/emr/trace/cdmp_20240129152437/emr_diag_10848_20240129152441.trc
Instance terminated by PMON, pid = 10837


MOS上一个BUG很类似：BUG ORA 7445 [kgh_get_shrinkable_grancnt()+136] (Doc ID 2492341.1)

解决办法：
    通过 设置 _library_cache_advice 为FALSE来临时解决。该办法就是阻止 MMON进程更新 共享池建议统计信息来解决：

    SQL> ALTER SYSTEM SET "_library_cache_advice"=false;