ORA-00600 Kcfrbd_3 appears in the query DBA_EXTENTS Solution

This article summarizes the ORA-00600 Kcfrbd_3 appear in the query DBA_EXTENTS solution, encountered such problems of friends can look.

In some cases, when querying the database's dba_extents dictionary table, you may encounter the ORA-600 kcfrbd_3 error, which is caused by file size and control file mismatch, the trigger may be caused by a database write exception, which can be eliminated by recreating the control file.
However, if the information in the data file header is incorrect and does not match the data file itself, you must modify the file size information in the data file header to solve the problem.

This issue is extremely rare. The following reference information is recorded in MOS Note 601798.1:

The Code is as follows:	Copy code
Oracle reports the ORA-00600: [kcfrbd_3] on a particle query. The same exception is encountered if you try to select DBA_EXTENTS using a FILE #/BLOCK #.

The following are the main parameters of the 600 error:

The Code is as follows:	Copy code
Ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kcfrbd_3], [13], [64011], [1], [64000], [64000], [], [] Arg [a] File number Arg [B] Block number Arg [c] Nro of blocks Arg [d] Logical File Size Arg [e] File Size

The first parameter is the file number. The following 13 is the file number:

The Code is as follows:

Copy code

SELECT segment_name, segment_type, owner, tablespace_name FROM sys. dba_extents WHERE file_id = 13 AND 64011 BETWEEN block_id and block_id + blocks-1; ERROR at line 2: ORA-00600: internal error code, arguments: [kcfrbd_3], [13], [66499], [1], [64000], [64000], [], [] Cause There is a temporary uption on the extent allocation table to tablespace that The file #13 belongs. For example, in this case, Datafile #13 is + DATA/ORCL/datafile/mgmt_tablespace.340.655388135 (FOB) flags = 512 fib = 0x1629c8f68 incno = 0 pending I/o cnt = 0 Fname = + DATA/ORCL/datafile/mgmt_tablespace.340.655388135 Fno = 13 lblksz = 8192 fsiz = 64000 We are trying to access the block 64011 that is beyond the number of blocks 6400.

In the simplest case, you can use the resize file to remove it.