This discussion is archived
1 Reply Latest reply: Feb 26, 2013 3:07 AM by LiuMaclean(刘相兵) RSS

查询dba_data_files报ORA-600 ktfbhget-4

993349 Newbie
Currently Being Moderated
查询dba_data_files出现下面报错:
SQL> select count(*) from dba_data_files;
select count(*) from dba_data_files
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfbhget-4], [0], [5], [], [], [], [], []
逐一查询dba_data_files视图相关表,定位x$ktfbhc查询时异常:
SQL> select count(*) from x$ktfbhc;
select count(*) from x$ktfbhc
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfbhget-4], [0], [5], [], [], [], [], []
其它故障现象:
1. 当sys用户创建表时,也会出现该问题:
SQL> create table iii as select * from dba_objects;
create table iii as select * from dba_objects
                                  *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfbhget-4], [0], [5], [], [], [],
[], []
如果在表放在其它表空间则正常:
SQL>  create table iii tablespace users as select * from dba_objects;
Table created.
2. system表空间有临时段未清除
SQL>  select * from dba_segments where segment_type='TEMPORARY';

OWNER                          SEGMENT_NAME                                                                      PARTITION_NAME                 SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ --------------------------------------------------------------------------------- ------------------------------ ------------------ ------------------------------
HEADER_FILE HEADER_BLOCK      BYTES     BLOCKS    EXTENTS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS FREELIST_GROUPS RELATIVE_FNO BUFFER_
----------- ------------ ---------- ---------- ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------------- ------------ -------
SYS                            1.29873                                                                                                          TEMPORARY          SYSTEM
          1        29873    1048576        128         16          65536                       1  2147483645                       1               1            1 DEFAULT
已尝试操作:
1. 禁用smon的临时段清理功能,故障仍然存在
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
event string 10061 trace name context forever, level 10

2. 手工删除临时段
alter session set events ‘immediate trace name DROP_SEGMENTS level 1′;
命令执行正常,但后台仍有600报错


3.重启数据后,该临时段仍然存在。

ORA-600 ktfbhget-4错误是否与临时段无法清除有关?
system表空间的临时段是否能手工删除?
谢谢大家!

Edited by: 990346 on 2013-2-26 上午12:42

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points