数据库的错误 ORA-00600

tonytang

环境：AIX 6.1 +ORACLE 10.2.0.40

             最近系统的并发很多，产生了很多的死锁，现在又在告警日志里面发现了不少的报错。都是内部错误，ORA-00600:.
现在发一下trace文件，请大家帮我看看。

另：能不能请大牛们告诉下如何查看这种类似的trace文件？

cargoo

Ora-00600 [Ktspgsb-1] Trying to Truncate Table [ID 787492.1]

      

Ora-00600 [Ktspgsb-1] Trying to Truncate Table [ID 787492.1]
		Modified 29-JUN-2012     Type PROBLEM     Status MODERATED

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to: Oracle Server - Enterprise Edition - Version 10.2.0.2 and later
Information  in this document applies to any platform.
This problem can occur on any platform.

*** Checked for currency on 29-Jun-2012 ***

SymptomsReceiving following error in alert.log numerous times:
ORA-00600: internal error code, arguments: [ktspgsb-1]
Trace files shows:
Current SQL statement for this session:
TRUNCATE TABLE P$DATA_OS_SPACE
Call stack may contain the functions:


ktspgsb1 ktsptrn_bmbs ktspcbmbs ktsstrn_segment kkbtts_trunc_tbl_se kkbtrn

CauseTable is corrupted.


SolutionTo implement the solution, drop and recreate the table.

Maclean Liu(刘相兵

ODM DATA:

10.2.0.4.0+ AIX

ORA-00600: internal error code, arguments: [ktspgsb-1], [], [], [], [], [], [], []
Current SQL statement for this session:
TRUNCATE TABLE VT5SONUXZ2IY0UU6W7L317IY27


stack call :

kkbtts_trunc_tbl_seg=>ktsstrn_segment=>ktspcbmbs=> ktsptrn_bmbs=>ktspgsb3=>kgeasnmierr


和Ora-00600 [Ktspgsb-1] Trying to Truncate Table  帖子描述的一致



考虑：


导出该表的DDL定义， 重新创建一个表空间， 在新的表空间上重建 该表