ORA-00600  and High BIND_MISMATCH, USER_BIND_PEEK_MISMATCH, OPTIMIZER_MODE_MISMATCH Counts When Running Batch Job
Last updated on FEBRUARY 07, 2014
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Oct-2013***
You have a batch job which performed acceptably in 10gR2 but now, in the 220.127.116.11 environment, it takes a very long time to run and you see the job terminates with an ORA-600  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.
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