My Oracle Support Banner

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

Last updated on APRIL 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.