Bruce, This may not be related at all, but I sometimes get ORA-00600 [smbalo_1] on an IOT when the "Analyze Table <The_Table> Estimate Statistics Sample x Percent" statement is executed against it. The table gets truncated and repopulated nightly and has about 544,000 rows.
What's weird is that a few weeks ago "... Sample 5 Percent" would produce the error, but 4 and 6 percent wouldn't. Just last night 6 percent started producing the error and now only 3 percent or lower will work. I haven't pursued it with Oracle Support, since we're soon to move to a new Win2k server with 8.1.7.2.5 (we're currently on 8.1.6.0.0 under Win2k) and I'm hoping the problem will just go away. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Bruce (CALBBAY) Sent: Thursday, November 22, 2001 8:15 PM To: Multiple recipients of list ORACLE-L Hi, We are testing the use of IOTs getting ready to implement 1 in production. During some of the testing we have encountered an ora-600 [ktbgcur_2] in the alert log. This has been logged with Oracle support to get an explanation of what this means but in the meantime I was wondering if anyone else has come across this? The all important version information: Oracle 8.1.7.1.4 - Windows NT4, Quad processor server with parallel degree of default on all tables and indexes. >From the alert log: Sun Nov 18 14:36:54 2001 Errors in file d:\oracle\admin\abcd\udump\ORA00657.TRC: ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] >From the user dump file (ora00657.trc mentioned above) *** 2001-11-18 14:36:54.843 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ktbgcur_2], [], [], [], [], [], [], [] Current SQL statement for this session: SELECT ANLY_ANALYSIS,ELMN_ELEMENT,ELEMENT_PERCENTAGE FROM ANALYSIS_ELEMENTS WHERE ROWID=:1 FOR UPDATE OF ANLY_ANALYSIS NOWAIT ----- Call Stack Trace ----- .... Any feedback would be appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
