ITPub博客

首页 > 数据库 > Oracle > ORA-600(ktspfnsb-1)错误

ORA-600(ktspfnsb-1)错误

Oracle 作者:dbhelper 时间:2015-01-15 15:35:36 0 删除 编辑

Exadata环境在收集统计信息时出现这个错误。

[@more@]

客户数据库11.2.0.2 RAC on Exadata在收集统计信息是出现的错误:

Sun Feb 05 22:22:44 2012
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc (incident=255085):
ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_255085/orcl2_j002_21084_i255085.trc
Sun Feb 05 22:22:56 2012
Thread 2 advanced to log sequence 6225 (LGWR switch)
Current log# 4 seq# 6225 mem# 0: +RECO_ORCL/orcl/onlinelog/group_4.683.768858471
.
.
.
Sun Feb 05 22:36:32 2012
Dumping diagnostic data in directory=[cdmp_20120205223632], requested by (instance=2, osid=21084 (J002)), summary=[incident=255085].
Sun Feb 05 22:36:32 2012
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Feb 05 22:36:32 2012
Sweep [inc][255085]: completed
Sweep [inc2][255085]: completed
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2878"
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 29628

根据错误信息,导致ORA-600[ktspfnsb-1]的是统计信息收集的JOB,这个问题毫无疑问属于Oracle的bug,查询MOS发现这个BUG虽然已经确认,但是还没有给出最终的解决方案:Bug 14694342 : DBMS_STATS.GATHER_TABLE_STATS FAILED WITH ORA-00600[KTSPFNSB-1][1][1]。

这个问题目前出现的概率很低,且问题发生在收集统计信息的过程中,对系统影响不大,且可以通过其他手段绕过,对系统影响不大,可以后期关注Oracle的解决方案。

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

下一篇: ORA-600(17067)错误
请登录后发表评论 登录
全部评论

注册时间:2017-10-14

  • 博文量
    651
  • 访问量
    392183