There're many articles on Metalink discussing ORA-600 [kcbgtcr_4]. Most of them don't provide immediate workarounds. But according to http://metalink.oracle.com/metalink/plsql/ml2_documents.showBUG?p_id=841636, the combination of _use_ism in Oracle which is true by default and a small shmsys:shminfo_shmmax in /etc/system may cause memory corruption. So we temporarily set _use_ism = false and bounced the database. Aaron restarted the job and is monitoring it. So far so good. Before we bounced the database, we even got that error by select count(*) from eis.descriptions in sqlplus. [Tech details: _use_ism uses Solaris intimate shared memory so all Oracle processes can use the same virtual-to-physical address translation table, thus saving memory. shmsys:shminfo_shmmax sets the maximum shared memory segment size. Beginning with 8.1.6, Oracle recommends setting it to the theoretical maximum, 4 billion on 32-bit OS. But on mcr this is only set to 268435456. The consequence is that `/usr/proc/bin/pmap -x [wprdOracleProcess] | grep shmid` shows too many shared memory segments instead of one. This not only slightly slows down instance startup and process creation, but triggers bugs like this] Another change we made, which is unlikely to be relevant, is alter tablespace temp temporary. It's been permanent since a very long time ago. Yong -----Original Message----- Sent: Monday, March 17, 2003 10:51 PM Subject: ERROR - Job: wfill_acctsum_interim.db SQL*Plus: Release 8.1.7.0.0 - Production on Mon Mar 17 22:08:12 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> Connected. SQL> DATE-TIME: 17-MAR-03 22:08:12 'fill_acctsum_interim ...' Table truncated. Elapsed: 00:00:00.46 Table altered. Elapsed: 00:00:00.02 declare * ERROR at line 1: ORA-00600: internal error code, arguments: [kcbgtcr_4], [116597], [116762], [1049601], [1], [], [], [] ORA-06512: at line 47 Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production CHECKING /oracle/logs/whsemgr/wfill_acctsum_interim.db.log.031703.2208 FOR ADDITIONAL ERRORS CTM_FINAL_CHECK_V2 FOUND ERROR: ORA-