GV$SQL_SHARED_CURSOR

select
inst_id,                 -- INST_ID NUMBER
kglhdadr,                -- ADDRESS RAW(4)
kglhdpar,                -- KGLHDPAR RAW(4)
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                   -- SEC_DEPTH_MISMATCH 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                   -- ROW_LEVEL_SEC_MISMATCH 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                   -- SQL_REDIRECT_MISMATCH VARCHAR2(1)
  (bitand (bitvector, POWER (2, 22)), POWER (2, 22), 'Y', 'N') 
from
x$kkscs
home |  up  |  mailbox