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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [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).
