GV$SQL_SHARED_CURSOR definition in Oracle Database 11.2
GV$SQL_SHARED_CURSOR
select
inst_id, -- INST_ID NUMBER
sql_id, -- SQL_ID VARCHAR2(13)
kglhdpar, -- ADDRESS RAW(8)
kglhdadr, -- CHILD_ADDRESS RAW(8)
childno, -- CHILD_NUMBER NUMBER
decode( -- UNBOUND_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,0)), POWER(2, 0), 'Y','N'),
decode( -- SQL_TYPE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,1)), POWER(2, 1), 'Y','N'),
decode( -- OPTIMIZER_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,2)), POWER(2, 2), 'Y','N'),
decode( -- OUTLINE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,3)), POWER(2, 3), 'Y','N'),
decode( -- STATS_ROW_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,4)), POWER(2, 4), 'Y','N'),
decode( -- LITERAL_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,5)), POWER(2, 5), 'Y','N'),
decode( -- FORCE_HARD_PARSE VARCHAR2(1)
bitand(bitvector, POWER(2,6)), POWER(2, 6), 'Y','N'),
decode( -- EXPLAIN_PLAN_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,7)), POWER(2, 7), 'Y','N'),
decode( -- BUFFERED_DML_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,8)), POWER(2, 8), 'Y','N'),
decode( -- PDML_ENV_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,9)), POWER(2, 9), 'Y','N'),
decode( -- INST_DRTLD_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,10)), POWER(2, 10), 'Y','N'),
decode( -- SLAVE_QC_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,11)), POWER(2, 11), 'Y','N'),
decode( -- TYPECHECK_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,12)), POWER(2, 12), 'Y','N'),
decode( -- AUTH_CHECK_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,13)), POWER(2, 13), 'Y','N'),
decode( -- BIND_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,14)), POWER(2, 14), 'Y','N'),
decode( -- DESCRIBE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,15)), POWER(2, 15), 'Y','N'),
decode( -- LANGUAGE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,16)), POWER(2, 16), 'Y','N'),
decode( -- TRANSLATION_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,17)), POWER(2, 17), 'Y','N'),
decode( -- BIND_EQUIV_FAILURE VARCHAR2(1)
bitand(bitvector, POWER(2,18)), POWER(2, 18), 'Y','N'),
decode( -- INSUFF_PRIVS VARCHAR2(1)
bitand(bitvector, POWER(2,19)), POWER(2, 19), 'Y','N'),
decode( -- INSUFF_PRIVS_REM VARCHAR2(1)
bitand(bitvector, POWER(2,20)), POWER(2, 20), 'Y','N'),
decode( -- REMOTE_TRANS_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,21)), POWER(2, 21), 'Y','N'),
decode( -- LOGMINER_SESSION_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,22)), POWER(2, 22), 'Y','N'),
decode( -- INCOMP_LTRL_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,23)), POWER(2, 23), 'Y','N'),
decode( -- OVERLAP_TIME_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,24)), POWER(2, 24), 'Y','N'),
decode( -- EDITION_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,25)), POWER(2, 25), 'Y','N'),
decode( -- MV_QUERY_GEN_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,26)), POWER(2, 26), 'Y','N'),
decode( -- USER_BIND_PEEK_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,27)), POWER(2, 27), 'Y','N'),
decode( -- TYPCHK_DEP_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,28)), POWER(2, 28), 'Y','N'),
decode( -- NO_TRIGGER_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,29)), POWER(2, 29), 'Y','N'),
decode( -- FLASHBACK_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,30)), POWER(2, 30), 'Y','N'),
decode( -- ANYDATA_TRANSFORMATION VARCHAR2(1)
bitand(bitvector, POWER(2,31)), POWER(2, 31), 'Y','N'),
decode( -- INCOMPLETE_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,32)), POWER(2, 32), 'Y','N'),
decode( -- TOP_LEVEL_RPI_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,33)), POWER(2, 33), 'Y','N'),
decode( -- DIFFERENT_LONG_LENGTH VARCHAR2(1)
bitand(bitvector, POWER(2,34)), POWER(2, 34), 'Y','N'),
decode( -- LOGICAL_STANDBY_APPLY VARCHAR2(1)
bitand(bitvector, POWER(2,35)), POWER(2, 35), 'Y','N'),
decode( -- DIFF_CALL_DURN VARCHAR2(1)
bitand(bitvector, POWER(2,36)), POWER(2, 36), 'Y','N'),
decode( -- BIND_UACS_DIFF VARCHAR2(1)
bitand(bitvector, POWER(2,37)), POWER(2, 37), 'Y','N'),
decode( -- PLSQL_CMP_SWITCHS_DIFF VARCHAR2(1)
bitand(bitvector, POWER(2,38)), POWER(2, 38), 'Y','N'),
decode( -- CURSOR_PARTS_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,39)), POWER(2, 39), 'Y','N'),
decode( -- STB_OBJECT_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,40)), POWER(2, 40), 'Y','N'),
decode( -- CROSSEDITION_TRIGGER_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,41)), POWER(2, 41), 'Y','N'),
decode( -- PQ_SLAVE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,42)), POWER(2, 42), 'Y','N'),
decode( -- TOP_LEVEL_DDL_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,43)), POWER(2, 43), 'Y','N'),
decode( -- MULTI_PX_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,44)), POWER(2, 44), 'Y','N'),
decode( -- BIND_PEEKED_PQ_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,45)), POWER(2, 45), 'Y','N'),
decode( -- MV_REWRITE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,46)), POWER(2, 46), 'Y','N'),
decode( -- ROLL_INVALID_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,47)), POWER(2, 47), 'Y','N'),
decode( -- OPTIMIZER_MODE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,48)), POWER(2, 48), 'Y','N'),
decode( -- PX_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,49)), POWER(2, 49), 'Y','N'),
decode( -- MV_STALEOBJ_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,50)), POWER(2, 50), 'Y','N'),
decode( -- FLASHBACK_TABLE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,51)), POWER(2, 51), 'Y','N'),
decode( -- LITREP_COMP_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,52)), POWER(2, 52), 'Y','N'),
decode( -- PLSQL_DEBUG VARCHAR2(1)
bitand(bitvector, POWER(2,53)), POWER(2, 53), 'Y','N'),
decode( -- LOAD_OPTIMIZER_STATS VARCHAR2(1)
bitand(bitvector, POWER(2,54)), POWER(2, 54), 'Y','N'),
decode( -- ACL_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,55)), POWER(2, 55), 'Y','N'),
decode( -- FLASHBACK_ARCHIVE_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,56)), POWER(2, 56), 'Y','N'),
decode( -- LOCK_USER_SCHEMA_FAILED VARCHAR2(1)
bitand(bitvector, POWER(2,57)), POWER(2, 57), 'Y','N'),
decode( -- REMOTE_MAPPING_MISMATCH VARCHAR2(1)
bitand(bitvector, POWER(2,58)), POWER(2, 58), 'Y','N'),
decode( -- LOAD_RUNTIME_HEAP_FAILED VARCHAR2(1)
bitand(bitvector, POWER(2,59)), POWER(2, 59), 'Y','N'),
decode( -- HASH_MATCH_FAILED VARCHAR2(1)
bitand(bitvector, POWER(2,60)), POWER(2, 60), 'Y','N'),
decode( -- PURGED_CURSOR VARCHAR2(1)
bitand(bitvector, POWER(2,61)), POWER(2, 61), 'Y','N'),
decode( -- BIND_LENGTH_UPGRADEABLE VARCHAR2(1)
bitand(bitvector, POWER(2,62)), POWER(2, 62), 'Y','N')
from
x$kkscs