ORA-600[17092] And ORA-16957 Reported While Running DBMS_SCHEDULER

(Doc ID 743873.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***


In the alert log file, the following errors are captured:

ORA-00600: internal error code, arguments: [17092], [16957], [], [], [], [], [], []
ORA-16957: SQL Analyze time limit interrupt

The failing statement looks like:

/* SQL Analyze(98,1) */ SELECT ..... FROM .........

The call stack is similar to:

... qxopqicf kxsffir kxsFreeExecutionHeap kksumc ... OCIStmtFetch2 qksanAnalyzeSql qksanAnalyzeSegSql kestseDoOneExec kestsePlansDoRounds kestseExecutePlans kestsaTestPlans kestsaAutoTuneDrv ...

The PL/SQL Call Stack is similar to:

package body SYS.PRVT_ADVISOR
package body SYS.PRVT_ADVISOR
package body SYS.DBMS_ADVISOR
package body SYS.DBMS_SQLTUNE

The application name reported in the trace file is DBMS_SCHEDULER.


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