GV$SQL_SHARED_CURSOR
select inst_id, -- INST_ID NUMBER sql_id, -- SQL_ID VARCHAR2(13) kglhdpar, -- ADDRESS RAW(4) kglhdadr, -- CHILD_ADDRESS RAW(4) 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 -- 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 -- 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 -- SQL_REDIRECT_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 -- ROW_SHIP_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') from x$kkscs

home |  up  |  mailbox