ORA-700 [kesqsMakeSql-invstat:elpsTime] / ORA-700 [kesqsMakeSql-invstat:cpuTime]

(Doc ID 811717.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

The following errors are reported daily in the alert log while running the SQL Tuning job:

ORA-700 [kesqsMakeSql-invstat:elpsTime]
ORA-700 [kesqsMakeSql-invstat:cpuTime]


The referenced trace file shows information like below:

ORA-00700: soft internal error, arguments: [kesqsMakeSql-invstat:elpsTime], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=6jbrg916bjmqc) -----
DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  BEGIN  DECLARE
         ename VARCHAR2(30);
       BEGIN
         ename := dbms_sqltune.execute_tuning_task(
                    'SYS_AUTO_SQL_TUNING_TASK');
       END;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0000000453F0BD30      7294  package body SYS.DBMS_SQLTUNE_INTERNAL
000000044F365B58         8  SYS.WRI$_ADV_SQLTUNE
000000044BD3CEB8       545  package body SYS.PRVT_ADVISOR
000000044BD3CEB8      2597  package body SYS.PRVT_ADVISOR
0000000457A528D0       241  package body SYS.DBMS_ADVISOR
0000000447EED340       702  package body SYS.DBMS_SQLTUNE
000000045B9717F0         4  anonymous block

----- Call Stack Trace -----
ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- PGOSF184_ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgesoftnmierr <- kesqsMakeSql <- kesqsMakeSqlCb <- kessiWorkloadFetch <- kesaiTuneSqlDrv <- spefcifa <- spefmccallstd <- pextproc <- PGOSF493_peftrust <- PGOSF519_psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- kpoodr <- xupirtrc <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- jslvec_execcb <- jslvswu <- jslve_execute0 <- jslve_execute <- rpiswu2 <- kkjex1e <- kkjsexe <- kkjrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms