internal error

the portuguese error message says: 'error in line 1, internal code error, arguments: ....'

what is that?



select a.file_name, b.phyrds + b.phywrts "Total I/O"
from dba_data_files a, v$filestat b
where a.file_id = b.file#
union
select a.file_name, b.phyrds "Total I/O"
from dba_temp_files a, v$filestat b
where a.file_id = b.file#
order by 2 desc;

select a.file_name, b.phyrds + b.phywrts "Total I/O"
*
ERRO na linha 1:
ORA-00600: código de erro interno, argumentos: [ktfthcf-1], [201], [], [], [],
[], [], []


F

Weird, that same code works in my DB, ver 8.1.7.4.0

MH

i got it in 9i
SQL*Plus: Release 9.2.0.2.0 - Production on Thu Jan 30 02:06:46 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


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

SQL> select a.file_name, b.phyrds + b.phywrts "Total I/O"
2 from dba_data_files a, v$filestat b
3 where a.file_id = b.file#
4 union
5 select a.file_name, b.phyrds "Total I/O"
6 from dba_temp_files a, v$filestat b
7 where a.file_id = b.file#
8 order by 2 desc;
select a.file_name, b.phyrds + b.phywrts "Total I/O"
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktfthcf-1], [203], [], [], [], [],
[], []

it's a bug.....err...undocumented feature rather :D

fixed in 10.0

log a tar to support and see if there is a one-off patch for it or possibly a workaround

steve

hey i did

alter session set optimizer_mode=rule ;

and then the querry ran smoothly :-)

meta link says
This error is caused by bug 1621216 which is fixed in Oracle9i.
This is an optimizer bug so you can workaround it by issuing an alter session set optimizer_mode=rule before the query.


But i got in 9i :-) may be u should wait for 10i (Packed with more newer bugs) :D

try

select /*+ ORDERED */ a.file_name, b.phyrds + b.phywrts "Total I/O"
from dba_data_files a, v$filestat b
where a.file_id = b.file#
union
select /*+ ORDERED */ a.file_name, b.phyrds "Total I/O"
from dba_temp_files a, v$filestat b
where a.file_id = b.file#
order by 2 desc

stmontgo, contact the support for me please I don't have the phone number :D


pando, it worked here now. pardon but I dont understand why it works with that hint and doesnt without the hint. I'm using 9i as adewri.




F