ORA-600 [15160]的处理

Fri Jun 12 09:07:37 2009
Errors in file /u01/oracle10/app/oracle/admin/SOURCE10/bdump/source10_cjq0_3559.trc:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
Fri Jun 12 09:07:41 2009
Errors in file /u01/oracle10/app/oracle/admin/SOURCE10/bdump/source10_cjq0_3559.trc:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], [], [], [], [], [], [], []

今天查询dba_objects报错，ORA-600 [15160]，运行的查询如下：
  SELECT * FROM Dba_Objects WHERE object_name LIKE 'V$FIX%'
实验了不加where,依然报错
  SELECT * FROM Dba_Objects

找到dba_objects的语句，一个基表一个基表的查询，没有问题，猜想是确定执行计划连接时候出现的问题。
查询METALINK:138428.1

  We are attempting to find a suitable table as the starting point in a complex join operation.
  This error is reported when a suitable table can not be indentified.

确认该ORA-600号是在确定基表是出错的

尝试重新收集统计值
 BEGIN
   dbms_stats.gather_dictionary_stats;
   dbms_stats.gather_fixed_objects_stats;
 END;
报错：
 Fri Jun 12 09:18:56 2009
 Errors in file /u01/oracle10/app/oracle/admin/SOURCE10/udump/source10_ora_3896.trc:
 ORA-07445: exception encountered: core dump [kkogbro()+550] [SIGSEGV] [Address not mapped to object] [0x10E] [] []

最后考虑下曲线救国，先删除在搞：由于是测试库，怕其他表也有问题，就把统计值全部干掉
exec dbms_stats.delete_database_stats;
exec dbms_stats.delete_system_stats;
exec dbms_stats.delete_fixed_objects_stats;
exec dbms_stats.delete_dictionary_stats;

OK，现在查询正常了，接着重新收集下统计值就是

ORACLE很多问题都和SQL的执行相关，前段时间朋友碰到给ORA-04030问题，最后的解决方法是重新收集统计值就搞定
 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8242091/viewspace-605996/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8242091/viewspace-605996/