ora-07445:exception encountered:core dump [kkorminl()+32] ......

ora-07445:exception encountered:core dump [kkorminl()+32] ......

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/killvoon/article/details/78070828

 加班中收到磁盘空间报警短信，/oracle目录使用率超过85%，登录服务器查看，发现diag下面的cdump目录大小超过十个G，

怀疑数据库存在问题，导致一直做dump导出信息，于是查看alert日志，发现如下报错：

ora-07445:exception encountered:core dump [kkorminl()+32] [SIGSEGV][ADDR:OxFFFFFFFFDFFFF8][PC:Ox105B4FB00][Address not mapped to object]

查了下之前的日志，发现这个错误发生在晚上十点后。

数据库版本是11.2.0.4，在mos上查了下，确实存在对应的bug，文档17339455.8：

 

Description

 
ORA-7445 [kkorminl] or similar can occur when running DBMS_SQLTUNE
Index Advisor on queries with inlists. This is most likely to occur when running 
an automatic tuning task that runs Index Advisor.
 
Workaround
 If the issue occurs during automatic tuning then an option to avoid the dumps is to
 disable the automatic tuning job.
 eg:
  BEGIN
   dbms_auto_task_admin.disable(
    client_name => 'sql tuning advisor',
    operation => NULL,
    window_name => NULL);
  END;
  /
 

 

意思在执行dbms_sqltune时候，存在问题，会报错。

 

查看alert日志，发现确实在报错之前，数据库上在运行automatic SQL Tuning Advisor

通过执行上述操作，停掉自动任务