Re: ORA-00600: Index produces timeout ?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Sat, 18 Apr 1998 12:55:10 +0800
Message-ID: <3538322E.42F4@bhp.com.au>

nat_at_object-factory.com wrote:
>
> In article <6h55gc$mdq$1_at_news01.btx.dtag.de>,
> GreMa_at_t-online.de (Matthias Gresz) wrote:
> >
> > Hi,
> >
> > take the time toread your docs:
> >
> > ORA-00600 internal error code, arguments: [num], [?], [?], [?], [?], [?]
> >
> > [lotsa oracle dox snipped]
> >
> ORA-00600 is Oracle's way of saying: "We crashed, but we
> can't tell you why...". I knew that, what's your point ?
>
> in reply to:
> > nat_at_object-factory.com schrieb:
> > >
> > > 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!
> > >
> >
> > Regards
> >
> > Matthias Gresz :-)
> >
> As I wrote in the first post:
>
> >>> I checked thru the
> >>> dox, various FAQs, DejaNews and AltaVista
> >>> but so far nothing panned out. I didn't contact
> >>> Oracle yet.
>
> Again what's your point ?
>
> Nat!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

This is a known bug with 7.3.2.3...fixed in 7.3.3

Workarounds: (my understanding was that it is a cost optimiser bug)

• delete the stats for the tables concerned
• use select "/* +RULE */"
• chuck out the indexes

HTH
Connor
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad." Received on Fri Apr 17 1998 - 23:55:10 CDT