'PX_MISMATCH: '||SUM(TO_NUMBER(DECODE(px_mismatch,'Y',1,'N','0'))),
'MV_STALEOBJ_MISMATCH: '||SUM(TO_NUMBER(DECODE(mv_staleobj_mismatch,'Y',1,'N','0'))),
'FLASHBACK_TABLE_MISMATCH: '||SUM(TO_NUMBER(DECODE(flashback_table_mismatch,'Y',1,'N','0'))),
'LITREP_COMP_MISMATCH: '||SUM(TO_NUMBER(DECODE(litrep_comp_mismatch,'Y',1,'N','0'))),
'PLSQL_DEBUG: '||SUM(TO_NUMBER(DECODE(plsql_debug,'Y',1,'N','0'))),
'LOAD_OPTIMIZER_STATS: '||SUM(TO_NUMBER(DECODE(load_optimizer_stats,'Y',1,'N','0'))),
'ACL_MISMATCH: '||SUM(TO_NUMBER(DECODE(acl_mismatch,'Y',1,'N','0'))),
'FLASHBACK_ARCHIVE_MISMATCH: '||SUM(TO_NUMBER(DECODE(flashback_archive_mismatch,'Y',1,'N','0'))),
'LOCK_USER_SCHEMA_FAILED: '||SUM(TO_NUMBER(DECODE(lock_user_schema_failed,'Y',1,'N','0'))),
'REMOTE_MAPPING_MISMATCH: '||SUM(TO_NUMBER(DECODE(remote_mapping_mismatch,'Y',1,'N','0'))),
'LOAD_RUNTIME_HEAP_FAILED: '||SUM(TO_NUMBER(DECODE(load_runtime_heap_failed,'Y',1,'N','0'))),
'HASH_MATCH_FAILED: '||SUM(TO_NUMBER(DECODE(hash_match_failed,'Y',1,'N','0'))),
'PURGED_CURSOR: '||SUM(TO_NUMBER(DECODE(purged_cursor,'Y',1,'N','0'))),
'BIND_LENGTH_UPGRADEABLE: '||SUM(TO_NUMBER(DECODE(bind_length_upgradeable,'Y',1,'N','0')))
FROM v$sql_shared_cursor
WHERE address IN (SELECT address
FROM v$sqlarea
WHERE sql_id = '
Example output:
UNBOUND_CURSOR: 0SQL_TYPE_MISMATCH: 0
OPTIMIZER_MISMATCH: 0
OUTLINE_MISMATCH: 0
STATS_ROW_MISMATCH: 0
LITERAL_MISMATCH: 0
FORCE_HARD_PARSE: 0
EXPLAIN_PLAN_CURSOR: 0
BUFFERED_DML_MISMATCH: 0
PDML_ENV_MISMATCH: 0
INST_DRTLD_MISMATCH: 0
SLAVE_QC_MISMATCH: 0
TYPECHECK_MISMATCH: 0
AUTH_CHECK_MISMATCH: 0
BIND_MISMATCH: 0
DESCRIBE_MISMATCH: 0
LANGUAGE_MISMATCH: 0
TRANSLATION_MISMATCH: 0
BIND_EQUIV_FAILURE: 0
INSUFF_PRIVS: 0
INSUFF_PRIVS_REM: 0
REMOTE_TRANS_MISMATCH: 0
LOGMINER_SESSION_MISMATCH: 0
INCOMP_LTRL_MISMATCH: 0
EDITION_MISMATCH: 0
MV_QUERY_GEN_MISMATCH: 0
USER_BIND_PEEK_MISMATCH: 0
TYPCHK_DEP_MISMATCH: 0
NO_TRIGGER_MISMATCH: 0
FLASHBACK_CURSOR: 0
ANYDATA_TRANSFORMATION: 0
INCOMPLETE_CURSOR: 0
TOP_LEVEL_RPI_CURSOR: 0
DIFFERENT_LONG_LENGTH: 0
LOGICAL_STANDBY_APPLY: 0
DIFF_CALL_DURN: 0
BIND_UACS_DIFF: 0
PLSQL_CMP_SWITCHS_DIFF: 0
CURSOR_PARTS_MISMATCH: 0
STB_OBJECT_MISMATCH: 0
CROSSEDITION_TRIGGER_MISMATCH : 0
PQ_SLAVE_MISMATCH: 0
TOP_LEVEL_DDL_MISMATCH: 476
MULTI_PX_MISMATCH: 0
BIND_PEEKED_PQ_MISMATCH: 0
MV_REWRITE_MISMATCH: 0
ROLL_INVALID_MISMATCH: 0
OPTIMIZER_MODE_MISMATCH: 0
PX_MISMATCH: 0
MV_STALEOBJ_MISMATCH: 0
FLASHBACK_TABLE_MISMATCH: 0
LITREP_COMP_MISMATCH: 0
PLSQL_DEBUG: 0
LOAD_OPTIMIZER_STATS: 0
ACL_MISMATCH: 0
FLASHBACK_ARCHIVE_MISMATCH: 0
LOCK_USER_SCHEMA_FAILED: 0
REMOTE_MAPPING_MISMATCH: 0
LOAD_RUNTIME_HEAP_FAILED: 0
HASH_MATCH_FAILED: 0
PURGED_CURSOR: 0
BIND_LENGTH_UPGRADEABLE: 0
This shows that the cursor is not shared because of TOP_LEVEL_DDL_MISMATCH which means this concerns a top DDL-statement and which would be expected behavior.
Conclusions and Summary of bugs due to reason code:
Look for the reason code you have identified by the above queries, check the affected version and use below table to identif