GATHER_FIXED_OBJECTS_STATS Is Erroring Out With ORA-20011: Approximate NDV Failed along with ORA-00600 [kggsmGetString:1]
(Doc ID 2728343.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; errors:
BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; END;
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[kggsmGetString:1], [0x000000000], [3], [0], [0], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 37180
ORA-06512: at line 1Trace file showing
*** 2020-10-30 16:14:50.813
Incident 15729501 created, dump file trc
ORA-00600: internal error code, arguments: [kggsmGetString:1], [0x000000000], [3], [0], [0], [], [], [], [], [], [], []Main Stack:
kggsmGetString <- kkocfbGetStringFromMapping <- kkotfbAddTimeHints
<- kkoarHintScanNRow <- kkoarHintFillRows <- kgligi <- kglic_cbk <- kglic0 <- kglic
<- kkoarHintsCB <- qerfxFetch <- qerandvFetch <- qergsFetch <- opifch2 <- kpoal8 <- opiodr
<- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpufch0 <- kpufch <- OCIStmtFetch2
<- qksanExecSql <- qksanAnalyzeSqlConCbk <- qksanAnalyzeSql <- qksanAnalyzeSegSql
<- kestsGatherSqlStatistics <- kestsProcessSql <- kestsProcessSqlCallout
<- spefcmpa <- spefmccallstd <- pextproc <- peftrusted <- psdexsp <- rpiswu2
<- kxe_push_env_internal_pp_ <- kkx_push_env_for_ICD_for_new_session <- psdextp
<- pefccal
Changes
None
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 |