ORA-01422 When Trying to Evolve SQL in 12.2
(Doc ID 2625701.1)
Last updated on MAY 01, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |
References |