HELP: internal error code, arguments [15599], [], ...

From: Vasily Kraskovsky <kvr_at_pe.spb.ru>
Date: 1997/10/16
Message-ID: <ABGTX2ua1T@pe.spb.ru>#1/1

Hi!
Recently I've got such a situation:
At the end of execution of rather simply query which is listed below

SELECT t1.t1_f1,

        t1.t1_f2,
        COUNT (*)
FROM    t1,
        t2
WHERE   t1.t1_f3 = t2.t2_f1
AND     t1.t1_f4 IN
        (
        SELECT  DISTINCT t3_f1
        from    t3
        where   t3_f2 IN (332, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346)
        AND     NOT t3_f3 IS NULL
        )

GROUP BY t1.t1_f1, t1.t1_f2;

I got an oracle server internal error:

ERROR:
ORA-00600: internal error code, arguments: [15599], [], [], [], [], [], [], []

Simultaneously I got oracle trace file, here is an extract form it:

SESSION ID:(43.95) 1997.10.09.16.42.02.000 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [15599], [], [], [], [], [], [], [] Current SQL statement for this session:

The error as well as error code are permanent [15599]. Inner distinct returns about 5000 rows.

o When I reduced number of rows to 2500 - it went fine; o When I took out inner distinct to view - it returned error.; o When I took out inner distinct to temporary table - it returned error; o When I replaced t3 by other table - it went fine.

Is it a bug? Or may be it is due to smth. else? Help!

Oracle7 Server Release 7.3.2.1.0 - Production Release PL/SQL Release 2.3.2.0.0 - Production
CORE Version 3.5.2.0.0 - Production
TNS for Intel SVR4 UNIX: Version 2.3.2.1.0 - Production NLSRTL Version 3.2.2.0.0 - Production

Intel Solaris 2.5.0

Thanks in advance.

--
                         Nemo solus sapit satis
         <<<<<<<<<<<<<<<<<<<<<<<<<< >>>>>>>>>>>>>>>>>>>>>>>>>>
Vasily Kraskovsky, Oracle DBA, Petersburg Express, St.Petersburg, Russia
                           vasily_at_kvr.spb.ru
                             kvr_at_pe.spb.ru

Received on Thu Oct 16 1997 - 00:00:00 CDT