Oracle Database Discussions

Hi all,

I have recently moved from EE Oracle 9.2.0.6 EE 11.1.0.6. I used to gather stats from my schema using DBMS_STATS package.

The following used to work in Oracle 9:

SQL> exec dbms_stats.gather_schema_stats('MY_SCHEMA',NULL,FALSE,'FOR ALL COLUMNS',NULL,'DEFAULT',TRUE);

This starts to execute and seemingly gather stats till a certain point then it craps out with the following error:

ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdcsaccc2], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_STATS", line 17964
ORA-06512: at "SYS.DBMS_STATS", line 18450
ORA-06512: at "SYS.DBMS_STATS", line 18531
ORA-06512: at "SYS.DBMS_STATS", line 18487
ORA-06512: at line 1

Is there a script I can run to recompile something that may be broken or does an internal error indicate I need to open a TAR with Oracle support?

Thanks!!!