My Oracle Support Banner

ORA-600 [15851] When Executing DBMS_STATS (Doc ID 1233291.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 08-Nov-2012***

Symptoms

Using Oracle 11.2.0.1, when attempting to run a query, the following error occurs:

ORA-00600: internal error code, arguments: [15851]

----- Current SQL Statement for this session (sql_id=dkv3ubuab9qmm) -----
select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120) minval,substrb(dump(max(val),16,0,32),1,120) maxval,sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val,min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */"SYS_NC00006$" val, ntile(254) over (order by "SYS_NC00006$") bkt from "<SCHEMA>"."<TABLE_NAME>" sample ( 4.9149270804) t where "SYS_NC00006$" is not null) group by val) group by maxbkt order by maxbkt
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
7000004df9a6f70 16623 package body SYS.DBMS_STATS

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.