ORA-20011: Approximate NDV Failed While Executing DBMS_STATS.GATHER_TABLE_STATS (Doc ID 2435964.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• While executing DBMS_STATS.GATHER_TABLE_STATS, error ORA-20011: Approximate NDV failed: ORA-00904 occurs
• Gathering errorstack  dumps following functions:
  SQL> sqlplus <username>/<password> as sysdba
  SQL> alter session set events '20011 trace name errorstack level 3';

  Then execute DBMS_STATS.GATHER_TABLE_STATS.

  Call stack from the trace generated:

  skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
  <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAct <- ions
  <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE <- 1063
  <- dbkePostKGE_kgsf <- kgeade <- kgerelv <- kgerev <- kserec1
  <- kkxerae <- pevm_icd_call_commo <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun
  <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8
  <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
  <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
  <- libc_start_main <- start

    
  
  
  

Cause

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