Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ora-600 when analyzing IOT
Ok, since my original message still hasn't arrived (sent couple hours ago), here it goes again (sorry, if you get duplicate).
First, sorry for asking this list before searching Metalink, but I don't
have access to it right now.
So, here it is:
I'm getting:
ORA-00600: internal error code, arguments: [15163], [333], [17424], [16191], [], [], [], []
when analyzing one of the index-organized tables:
"ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS".
Now, similar statement analyzing other IOTs works fine.
Also, on the same table (ipn_measurement) analyze worked fine yesterday, and the table didn't grew too much since yesterday.
Any ideas?
Another question, do I really have to run "analyze table" on IOT for cost-based optimizer, or analyzing index would be enough:
"ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS"
because "analyze index" still runs with no errors.
Oracle version is 8.1.5.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman_at_perceptron.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Thu Aug 07 2003 - 11:44:24 CDT
![]() |
![]() |