Database Tuning (MOSC)

MOSC Banner

Child cursors not shared

edited Dec 8, 2010 3:54PM in Database Tuning (MOSC) 3 commentsAnswered
 Hi,
In database version 11.2.0.1, child cursors are not getting shared and the following mismatch is seen in the below columns in the v$sql_shared_cursor view:-
LANGUAGE_MISMATCH,
ROLL_INVALID_MISMATCH,
BIND_LENGTH_UPGRADEABLE.

The customer has newly installed 11.2.0.1 database and initially he did not face this issue but all of a sudden out of the blue the issue started occurring, are we seeing any BUG here?

Can anybody just throw some light on the following issue?

The application is JDBC and the Operating system is Windows 64bit.

The query is an simple insert query with bind variables.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center