Re: runaway db processes after index creation?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Nov 2000 23:51:20 +0100
Message-ID: <90449f$64m0$4@ID-62141.news.dfncis.de>

Ora-600 means "call support"

Hth,

Sybrand Bakker, Oracle DBA

"Eliot Shepard" <eshepard_at_yahoo.com> wrote in message news:t2ataq19f3jpd6_at_corp.supernews.com...
> I added a non-unique descending index to a table in our DB, and
> immediately started noticing problems with the server. Oracle processes
> would lock up at high CPU usage. Our server monitor then started new ones,
> and the whole thing would just go haywire.
>
> Here's an index I created. PUBLICATION_DATE is of type DATE. The table
> already has a unique primary key index.
>
> CREATE INDEX THE451.ENTITIES_PUBDATE_IDX
> ON THE451.T451_ENTITIES(PUBLICATION_DATE DESC)
>
> I noticed this in the alert log:
>
> alert_the451.log:ORA-00600: internal error code, arguments: [kcbgtcr_5],
> [1], [6], [25184429], [3427], [3426], [0], []
>
> Environment: SunOS 5.6, Oracle 8.1.6
>
> Any ideas? Thanks.
>
> Eliot
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Wed Nov 29 2000 - 16:51:20 CST