SQL Performance (MOSC)

MOSC Banner

Getting more detailed information about cursor LANGUAGE_MISMATCH?

edited Nov 29, 2019 4:03AM in SQL Performance (MOSC) 2 commentsAnswered

Hello,

In a 12.2 database with the April '19 RU applied, I'm trying to get more information about child cursors that can't be shared due to LANGUAGE_MISMATCH.

There are examples where querying for the mismatch reason shows output like this:

SQL> select DBMS_LOB.SUBSTR(REASON,4000,1) from v$sql_shared_cursor where sql_id='a9x5sbz88kmfh';

<ChildNode><ChildNumber>3</ChildNumber><ID>45</ID><reason>NLS Settings(2)</reason><size>2x568</size><NLS_TERRITORY>'THE NETHERLANDS'->'BELGIUM'</NLS_TERRITORY><NLS_ISO_CURRENCY>'THE NETHERLANDS'->'BELGIUM'</NLS_ISO_CURRENCY></ChildNode>

In our database, the v$sql_shared_cursor view has less information:

<ChildNode><ChildNumber>0</ChildNumber><ID>44</ID><reason>NLS Settings(2)</reason><size>2x568</size></ChildNode>

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