internal error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: internal error

  1. #1
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Weird, that same code works in my DB, ver 8.1.7.4.0

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Talking

    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

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  8. #8
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    Post

    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
  •  


Click Here to Expand Forum to Full Width