| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: IOT and ora-600 [ktbgcur_2] on NT 81714
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
-----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:bruce.reardon_at_comalco.riotinto.com.au
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: japplewhite_at_inetprofit.com 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: ListGuru_at_fatcity.com (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).Received on Mon Nov 26 2001 - 09:57:28 CST
 |
 |