-
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 remember when this place was cool.
-
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], [], [], [], [],
[], []
Amar
"There is a difference between knowing the path and walking the path."
-
it's a bug.....err...undocumented feature rather
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
I'm stmontgo and I approve of this message
-
hey i did
alter session set optimizer_mode=rule ;
and then the querry ran smoothly :-)
Amar
"There is a difference between knowing the path and walking the path."
-
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)
Amar
"There is a difference between knowing the path and walking the path."
-
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
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|