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

[EMAIL PROTECTED]

Reply via email to