ORA-600 [15851] When Executing DBMS_STATS
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