runaway db processes after index creation?

From: Eliot Shepard <eshepard_at_yahoo.com>
Date: Wed, 29 Nov 2000 21:30:02 -0000
Message-ID: <t2ataq19f3jpd6@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 - 15:30:02 CST