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/，如需轉載，請註明出處，否則將追究法律責任。