Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ora-600 when analyzing IOT
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.
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 - 09:59:29 CDT
![]() |
![]() |