RE: Statspack recomendations.

[Mark Leith]

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