Why a SQL text cannot be shared on one of node in RAC database environment?
Dear experts,
I've got a stranage problem in recently that in my an oracle RAC database(19c and has two nodes). There's a sql text has got very high version accounts which was reported by version_rpt.sql with reason BIND_EQUIV_FAILURE and ROLL_INVALID_MISMATCH and both of them has 524 accounts been promoted like below:
Versions Summary
----------------
BIND_EQUIV_FAILURE :524
ROLL_INVALID_MISMATCH :524
Total Versions:524
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
cursor_sharing = EXACT
_cursor_obsolete_threshold = 8192 (See Note:10187168.8)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Plan Hash Value Summary
-----------------------
Plan Hash Value Count
=============== =====
2710437141 245
1769124750 280
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Details for BIND_EQUIV_FAILURE :
Consolidated details for BIND* columns:
BIND_MISMATCH,USER_BIND_PEEK_MISMATCH,BIND_UACS_DIFF,BIND_LENGTH_UPGRADEABLE,etc and