ora-07445:exception encountered:core dump [kkorminl()+32] ......
来源:互联网 发布:淘宝宝贝上架编辑技巧 编辑:程序博客网 时间:2024/06/05 06:12
加班中收到磁盘空间报警短信,/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
意思在执行dbms_sqltune时候,存在问题,会报错。ORA-7445 [kkorminl] or similar can occur when running DBMS_SQLTUNEIndex 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; /
查看alert日志,发现确实在报错之前,数据库上在运行automatic SQL Tuning Advisor
通过执行上述操作,停掉自动任务
阅读全文
0 0
- ora-07445:exception encountered:core dump [kkorminl()+32] ......
- ORA-07445: exception encountered: core dump
- ORA-07445: exception encountered: core dump [hok2beg()+191]
- ORA-07445: exception encountered: core dump [qervwFetch()+338]
- ORA-07445: exception encountered: core dump [qctosop()+1504]
- 报错:ORA-07445: exception encountered: core dump [kkqtnloCbk()+111] [SIGSEGV]
- ORA-07445: exception encountered: core dump [kkslpli()+199] [SIGSEGV] [ADDR:0x2B5BEC7F5EA0] [PC:0x1E
- ORA-07445: exception encountered: core dump [00000000] [SIGILL] [Illegal opcode] [0x000000000] [] []
- ORA-7445 exception encountered:core dump[qksopVisitOpns+62] 核心存储错误,解决方法
- ora-7445 exception encountered: core dump [ksmpgd_init_ctx()+4] [SIGSEGV] [Address not mapped to obj
- ORA-07445 core dump [kttuser0()+393] [INT_DIVIDE_BY_ZERO] [] [PC:0x160A463] [] []
- Core Dump
- Core Dump
- Core Dump?!
- Core Dump?!
- Core Dump?!
- core dump
- core dump
- android源码下载
- PHP
- 关于:char (*p)[10] 、char p[10]和char *p[10]的讨论
- angularjs ng-repeat 嵌套 获取上层$index
- gen下的R文件报错
- ora-07445:exception encountered:core dump [kkorminl()+32] ......
- delphi 7无法运行提示 Borland license information was found, but it is not valid for Delphi
- BugFree&&TestLink安装以及配置
- 从零开始前端学习[19]:前端中重要的属性,定位position属性
- Python基础 —— 获取当前文件所在目录,遍历当前目录,获取指定后缀的文件
- 51nod 1240 莫比乌斯函数
- 欢迎使用CSDN-markdown编辑器
- 深圳鑫飞分享液晶广告机的使用注意事项
- 欢迎使用CSDN-markdown编辑器