Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

3

积分

0

好友

4

主题
1#
发表于 2013-1-17 11:39:19 | 查看: 3036| 回复: 1
alert中报错信息(由于涉及信息安全,信息已经处理):
Wed Jan 16 22:00:02 2013
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
Wed Jan 16 22:13:45 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xB00000001] [PC:0x4000000010E230D0, lnxmin()+1936] [flags: 0x0, count: 1]
Errors in file /oracle11g/app/oracle/diag/rdbms/XXXX/trace/XXXX_j000_23423.trc  (incident=12201):
ORA-07445: exception encountered: core dump [lnxmin()+1936] [SIGSEGV] [ADDR:0xB00000001] [PC:0x4000000010E230D0] [Address not mapped to object] []
Incident details in: /oracle11g/app/oracle/diag/rdbms/XXXX/incident/incdir_12201/XXXX_j000_23423_i12201.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Jan 16 22:13:57 2013
Errors in file /oracle11g/app/oracle/diag/rdbms/XXXX/incident/incdir_12201/XXXX_j000_23423_i12201.trc:
ORA-16957: SQL Analyze time limit interrupt
ORA-07445: exception encountered: core dump [lnxmin()+1936] [SIGSEGV] [ADDR:0xB00000001] [PC:0x4000000010E230D0] [Address not mapped to object] []
Errors in file /oracle11g/app/oracle/diag/rdbms/XXXX/incident/incdir_12201/XXXX_j000_23423_i12201.trc:
ORA-16957: SQL Analyze time limit interrupt
ORA-07445: exception encountered: core dump [lnxmin()+1936] [SIGSEGV] [ADDR:0xB00000001] [PC:0x4000000010E230D0] [Address not mapped to object] []
Errors in file /oracle11g/app/oracle/diag/rdbms/XXXX/incident/incdir_12201/XXXX_j000_23423_i12201.trc:
ORA-16957: SQL Analyze time limit interrupt
ORA-07445: exception encountered: core dump [lnxmin()+1936] [SIGSEGV] [ADDR:0xB00000001] [PC:0x4000000010E230D0] [Address not mapped to object] []
Wed Jan 16 22:16:25 2013
Sweep [inc][12201]: completed
Thu Jan 17 02:52:32 2013

刘大,同样由于安全需要,trace不能发布附件,如果需要单独发送给您。
从日志上看应该是自动收集统计信息的job报告出来的。
问题:
1.lnxmin函数是做什么用的呢?
2.该问题在搜索mos后没有什么有用的结果,查询出来的多数都是bug,但是数据库是新装的,相关补丁都已经安装了,详见附件。
2#
发表于 2013-1-18 21:11:02
    经过原厂工程师检查,确认该7445问题是由于sql auto tuning advisor在晚上自动运行导致的!原因可能是sql语句中有order by count operation导致,可能是碰到了bug 10324251!
    可以使用下面的办法解决,把sql auto tuning advisor关闭掉!
SQL> begin
  2  DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'sql tuning advisor',
  3  operation => NULL,
  4  window_name => NULL);
  5  end;
  6  /

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 08:55 , Processed in 0.046375 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569