Oracle-L: RE: Statspack recomendations.

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 24 Jan 2003 07:59:01 -0800
Message-ID: <F001.00539BA1.20030124075901@fatcity.com>

I also get it on 9.2.0.1 on Win2K, same error code as Robert:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> select a.file_name
2 from dba_temp_files a, v$tempstat b 3 where b.file#=a.file_id;
ERROR:
ORA-00600: internal error code, arguments: [ktfthcf-1], [202], [], [], [], [],
[], []

Though on 9.0.1.3.1 it works (same machine):

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.3.1 - Production With the Partitioning option
JServer Release 9.0.1.3.0 - Production

SQL> select a.file_name
2 from dba_temp_files a, v$tempstat b 3 where b.file#=a.file_id;

FILE_NAME

C:\ORACLE\APP92\ORADATA\IASDB\DISCOTEMP1.DBF
C:\ORACLE\APP92\ORADATA\IASDB\PTLTMP.DBF
C:\ORACLE\APP92\ORADATA\IASDB\TEMP01.DBF

Mark

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 24 2003 - 09:59:01 CST