Getting more detailed information about cursor LANGUAGE_MISMATCH?
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>