这篇博客详细记录了遇到Oracle数据库中SYS_AUTO_SQL_TUNING_TASK任务导致的ORA-07445错误的完整过程。博主首先展示了报错信息，接着分析了trc文件，发现可能由特定SQL_ID的语句引起。手动执行该SQL并未发现问题，但在使用DBMS_SQLTUNE进行调优时出现连接中断的错误。博主推测这可能是系统bug。最后，提供了两种处理方案：修改错误的SQL或关闭并重新启用SQL调优顾问的自动任务。
1.先贴报错
----敏感信息已经经过处理
Fri Sep 30 11:01:37 2016
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Fri Sep 30 11:01:50 2016
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFF82C72FF8] [PC:0x9541BA4, kkorminl()+306] [flags: 0x0, count: 1]
Errors in file /home/app/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_j000_78729.trc (incident=48167):
ORA-07445: exception encountered: core dump [kkorminl()+306] [SIGSEGV] [ADDR:0x7FFF82C72FF8] [PC:0x9541BA4] [Address not mapped to object] []
Incident details in: /home/app/oracle/diag/rdbms/orcl11g/orcl11g/incident/incdir_48167/orcl11g_j000_78729_i48167.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fr
最低0.47元/天 解锁文章
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
