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/