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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
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 "DMKNPS02P"."HLP_STOCK_LOAD" 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms