1 Reply Latest reply: Feb 26, 2013 5:07 AM by LiuMaclean(刘相兵) RSS

    查询dba_data_files报ORA-600 ktfbhget-4

    993349
      查询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