ORA-600 [15851] When Executing DBMS_STATS
(Doc ID 1233291.1)
Last updated on JANUARY 30, 2022
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.
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 |