ORA-20011: Approximate NDV failed: ORA-00600: internal error code Running adstats.sql

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

Problem:While running adstats.sql, the following error occurs:

--------------------------------------------------
--- adstats.sql started at 2013-09-03 14:08:43 ---


Checking for the DB version and collecting statistics ...

declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [1], [23], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 24889
ORA-06512: at "SYS.DBMS_STATS", line 25430
ORA-06512: at line 3
ORA-06512: at line 33


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options

D:\ORACLE\MFGPR12\db\tech_st\11.2.0>

Solution: Bounce database, then retry script.

Note: Make sure that you have at least 1.5 GB of free default temporary tablespace.