ORA-00600 [17147] Querying DBA_FREE_SPACE And/Or X$KTFBFE (Doc ID 553087.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

This problem was observer on 10.2.0.3 on a Solaris 64-bit server trying to check tablespace space using OEM client utility.

The local errors may look like this:

VBO-1508 : An error has occurred and server object could not be initialized.
Please disconnect and try again.
ORA-03113: end-of-file communication channel.

followed by another message as follows:
VTO-2013 : server object could not be sufficiently initialized. Please
disconnect and try again. Necessary initialization level: 2

 

The alert log shows this error:

ORA-00600: internal error code, arguments: [17147], [0xFFFFFFFF7AE0D9B0]


The failing statement is similar to this:

/* OracleOEM */ SELECT /*+ use_hash(d v) */ d.file_name, v.status, TO_CHAR((d. bytes / 1024 / 1024), '99999990.000'), NVL(TO_CHAR(((d.bytes - s.bytes) / 1024 / 1024), '99999990.000'), TO_CHAR((d.bytes / 1024 / 1024), '99999990.000')), d. file_id, d.autoextensible, d.increment_by, d.maxblocks FROM sys.dba_data_files d, v$datafile v, (SELECT file_id, SUM(bytes) bytes FROM sys.dba_free_space WHERE tablespace_name = 'RIMSSTG' GROUP BY file_id) s WHERE (s.file_id (+)= d. file_id) AND (d.tablespace_name = 'RIMSSTG') AND (d.file_name = v.name)


The explain plan shows querying DBA_FREE_SPACE and/or X$KTFBFE

----------------------+....
.....
| 62 | FIXED TABLE FULL | X$KTFBFE | |
| | |
| 63 | TABLE ACCESS BY INDEX ROWID | FILE$ | |
| | |
| 64 | INDEX UNIQUE SCAN | I_FILE2 | |
| | |
...
------------------------------------------------------------------+---------



The function stack may look like this:

kghfrf ktfbfef qerfxFetch qerflFetch rwsfcd qerjotFetch qerjotFetch rwsfcd
qeruaFetch qervwFetch qergsFetch qervwFetch qersoFetch . . .

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms