ORA-00600 [17059] and High BIND_MISMATCH, USER_BIND_PEEK_MISMATCH, OPTIMIZER_MODE_MISMATCH Counts When Running Batch Job (Doc ID 968930.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Oct-2013***

Symptoms

You have a  batch job which performed acceptably in 10gR2 but now, in the 11.1.0.7 environment, it takes a very long time to run and you see the job terminates with an ORA-600 [17059] error.

When running through the report script in
<Note 438755.1> - High SQL Version Counts - Script to determine reason(s)
you see very high counts for BIND_MISMATCH, USER_BIND_PEEK_MISMATCH and OPTIMIZER_MODE_MISMATCH.

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