ORA-1426 From Gather Stats Job on 18.x (Doc ID 2711489.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• While  the auto stats job is running it is possible that an ORA-1426 numeric overflow can be encountered:
  --- Error Stack Dump -----
  ORA-01426: numeric overflow
  <error barrier> at 0x7ffedb5d06a8 placed kpoodr.c@237
  ----- Current SQL Statement for this session (sql_id=5r6gvp2whv3gd) -----
  call sys.dbms_stats.gather_database_stats_job_proc ( )
  ----- PL/SQL Stack -----
  ----- PL/SQL Call Stack -----
  object line object
  handle number name
  0x696b83b8 10609 package body SYS.DBMS_STATS.TOLERANT_SET_SESSION_LONGOPS
  0x696b83b8 39401 package body SYS.DBMS_STATS.GATHER_GROUP_STATS
  0x696b83b8 49428 package body SYS.DBMS_STATS.GATHER_DB_STATS_JOB_PROC_AUX
  0x696b83b8 49497 package body SYS.DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC

  --- Call Stack Trace -----

  ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
  <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventActions
  <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- dbgePostErrorKGE <- 1140 <- dbkePostKGE_kgsf
  <- kgeade <- kgerelv <- kgerec0 <- pfrrexc_record_excp <- pfrexc
  <- pfrrun <- plsql_run <- peidxr_run <- peidxexe <- kkxdexe
  <- kkxmpexe <- kgmexwi <- kgmexec <- evapls <- evaopn2
  <- kkxmexcs <- opiexe <- kpoal8 <- opiodr <- kpoodr
  <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- jslvec_execcb1
  <- jslvswu <- jslvCDBSwitchUsr <- 263 <- jslve_execute0 <- jslve_execute
  <- jslve_cdb_execute <- rpiswu2 <- kkjex1e_cdb <- kkjsexe <- kkjrdp
  <- opirip <- 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.