ORA-01422 When Trying to Evolve SQL in 12.2 (Doc ID 2625701.1)

Last updated on MAY 01, 2020

Applies to:

Symptoms

• ORA-01422 error occurs during evolve task in 12.2 database
• Setting errorstack event, alter session set events '1422 trace name errorstack level 3;
  
  ORA-01422: exact fetch returns more than requested number of rows
  ----- PL/SQL Call Stack -----
  object line object
  handle number name
  0x197f22dd0 3654 package body SYS.DBMS_SPM_INTERNAL.LOAD_ALTERNATE_PLANS
  0x31f920098 13887 package body SYS.DBMS_SQLTUNE_INTERNAL.I_SUB_EXECUTE_CALLOUT
  0x31f920098 13907 package body SYS.DBMS_SQLTUNE_INTERNAL.I_SUB_EXECUTE
  0x297d4cdd8 7 type body SYS.WRI$_ADV_SPM_EVOLVE.SUB_EXECUTE
  0x31f90cd30 739 package body SYS.PRVT_ADVISOR.COMMON_SUB_EXECUTE
  0x31f90cd30 3238 package body SYS.PRVT_ADVISOR.COMMON_EXECUTE_TASK
  0x2ff7e5ad0 262 package body SYS.DBMS_ADVISOR.EXECUTE_TASK
  0x81bc6c730 2695 package body SYS.DBMS_SPM.EXECUTE_EVOLVE_TASK
  <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXECC
  <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peidxr_run
  <- peidxexe <- kkxdexe <- kkxmpexe <- kgmexwi <- kgmexec <- evapls <- evaopn2
  <- kkxmexcs <- opiexe <- kpoal8 <- opiodr <- kpoodr <- xupirtrc <- kpurcsc
  <- kpuexec <- OCIStmtExecute <- keswspmBegin <- kesaiTuneSqlDrv <- 952 <- spefcifa
  <- spefmccallstd <- pextproc <- peftrusted <- psdexsp <- rpiswu2 <- kxe_push_env_intern
  <- al_pp_ <- kkx_push_env_for_IC <- D_for_new_session <- psdextp
  <- D_for_new_session <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL
  <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe
  <- opiexe <- kpoal8
    
  

Cause

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