Re: ORA-00600: Index produces timeout ?

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Thu, 16 Apr 1998 20:06:28 GMT
Message-ID: <35366398.814036@news.ipf.net>

On Thu, 16 Apr 1998 04:22:48 -0600, nat_at_object-factory.com wrote:

>In article <352D2004.CA6AA7DE_at_nowhere.com>,
> Jojo <jojo_at_nowhere.com> wrote:
>>
>> Have you done analyze table validate structure yet ?
>> Your table maybe corrupted .
>
>Yes I have. It didn't complain. I have now dropped a lot of
>the indexes and so far things look OK.
>As other people suggested, I will contact Oracle about it...
>
>Nat!

Hi again :-)

I didn't find my docs on this error, but I was able to find the following info on an older issue of the Developer CD-ROM, I think it matches your symptoms.

<quote>

Document ID:         11786436.61
Title:               Core Dump or ORA 8103 Errors from various SQL statements
Creation Date:       24-January-1997
Last Revision Date:  22-April-1997
Revision Number:     1
Product:             RDBMS
Product Version:     7.3.2.3
Platform:            LISTED
Information Type:    ADVISORY
Impact:              HIGH
Abstract:            Certain SQL statements may fail with either an Oracle
                     Error ORA 8103 or a core dump in the function KCBGTCR.
                     More specifically, the problem is most likely to occur
                     in SQL statements using AND-EQUAL access paths.  This
                     problem only affects Server release 7.3.2.3 for certain
                     platforms, listed in the bulletin.  The bug is fixed in
                     release 7.3.3.
Keywords:            ORA-8103;AND-EQUAL;DUMP;QUERY;SQL;STATEMENT
________________________________________________________________________________

Bug: 424581 Core Dump or ORA 8103 Errors from various SQL statements

Versions Affected

This problem only affects Oracle Server release 7.3.2.3 on certain platforms.

Ports Affected

    Port                        Oracle Bug Reference
    ~~~~                        ~~~~~~~~~~~~~~~~~~~~
    Alpha OSF / Digital Unix    -               **1
    DG Aviion 88K               Bug:425100
    DG Aviion Intel             Bug:425102
    HPUX                        Bug:437448      **2
    NCR 3000 Unix (Svr4)        Bug:425217
    NEC UX/4800 UP/EWS 4800     Bug:425912
    Sequent PTX                 Bug:425040
    Sun Solaris 5.x             Bug:425483
    Sun Solaris Intel           Bug:425519
    UnixWare                    Bug:425981

All other ports have the relevant bug fixed in the 7.3.2.3 patch release.

**1: The patch for Bug:424581 is included in the 7.3.2.3 patch release

*BUT* Digital Unix "4.0" requires the patch for <Bug:424307>

**2: Note that the HPUX 7.3.2.3 patch release notes state that this bug is

         fixed in the patch. This is incorrect - you need to apply fix 437448
         after installing 7.3.2.3.

Description

Certain SQL statements may fail with either an Oracle Error ORA 8103 or a core dump in the function KCBGTCR. More specifically, the problem is most likely to occur in SQL statements using AND-EQUAL access paths.

Likelihood of Occurrence

It is highly likely this problem will be encountered on any of the Oracle ports listed above on 7.3.2.3, especially if AND-EQUAL access paths are used.

Possible Symptoms

Symptoms include:

        ORA 7445 with 'kcbgtcr' in the argument list or stack trace.
        ORA 8103 from AND-EQUAL type queries.
        Incorrect query results from AND-EQUAL type queries.

Workaround / Patches

For some queries you may be able to disable AND-EQUAL steps in the execution plan. It is recommended that a patch be applied in all cases. You should first make sure 7.3.2.3 is fully installed then apply the relevant patch.

Contact Oracle Worldwide Support regarding availability of patches for the platforms listed above.

                                             Oracle WorldWide Customer Support

</quote>

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Thu Apr 16 1998 - 15:06:28 CDT