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 10.2.0.4 to 11.1.0.6 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

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.DBMS_SQLTUNE_INTERNAL
                      SYS.WRI$_ADV_SQLTUNE
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.

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