select
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  ADDRESS,                                 -- ADDRESS RAW(8)
  CHILD_ADDRESS,                           -- CHILD_ADDRESS RAW(8)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  UNBOUND_CURSOR,                          -- UNBOUND_CURSOR VARCHAR2(1)
  SQL_TYPE_MISMATCH,                       -- SQL_TYPE_MISMATCH VARCHAR2(1)
  OPTIMIZER_MISMATCH,                      -- OPTIMIZER_MISMATCH VARCHAR2(1)
  OUTLINE_MISMATCH,                        -- OUTLINE_MISMATCH VARCHAR2(1)
  STATS_ROW_MISMATCH,                      -- STATS_ROW_MISMATCH VARCHAR2(1)
  LITERAL_MISMATCH,                        -- LITERAL_MISMATCH VARCHAR2(1)
  FORCE_HARD_PARSE,                        -- FORCE_HARD_PARSE VARCHAR2(1)
  EXPLAIN_PLAN_CURSOR,                     -- EXPLAIN_PLAN_CURSOR VARCHAR2(1)
  BUFFERED_DML_MISMATCH,                   -- BUFFERED_DML_MISMATCH VARCHAR2(1)
  PDML_ENV_MISMATCH,                       -- PDML_ENV_MISMATCH VARCHAR2(1)
  INST_DRTLD_MISMATCH,                     -- INST_DRTLD_MISMATCH VARCHAR2(1)
  SLAVE_QC_MISMATCH,                       -- SLAVE_QC_MISMATCH VARCHAR2(1)
  TYPECHECK_MISMATCH,                      -- TYPECHECK_MISMATCH VARCHAR2(1)
  AUTH_CHECK_MISMATCH,                     -- AUTH_CHECK_MISMATCH VARCHAR2(1)
  BIND_MISMATCH,                           -- BIND_MISMATCH VARCHAR2(1)
  DESCRIBE_MISMATCH,                       -- DESCRIBE_MISMATCH VARCHAR2(1)
  LANGUAGE_MISMATCH,                       -- LANGUAGE_MISMATCH VARCHAR2(1)
  TRANSLATION_MISMATCH,                    -- TRANSLATION_MISMATCH VARCHAR2(1)
  BIND_EQUIV_FAILURE,                      -- BIND_EQUIV_FAILURE VARCHAR2(1)
  INSUFF_PRIVS,                            -- INSUFF_PRIVS VARCHAR2(1)
  INSUFF_PRIVS_REM,                        -- INSUFF_PRIVS_REM VARCHAR2(1)
  REMOTE_TRANS_MISMATCH,                   -- REMOTE_TRANS_MISMATCH VARCHAR2(1)
  LOGMINER_SESSION_MISMATCH,               -- LOGMINER_SESSION_MISMATCH VARCHAR2(1)
  INCOMP_LTRL_MISMATCH,                    -- INCOMP_LTRL_MISMATCH VARCHAR2(1)
  OVERLAP_TIME_MISMATCH,                   -- OVERLAP_TIME_MISMATCH VARCHAR2(1)
  EDITION_MISMATCH,                        -- EDITION_MISMATCH VARCHAR2(1)
  MV_QUERY_GEN_MISMATCH,                   -- MV_QUERY_GEN_MISMATCH VARCHAR2(1)
  USER_BIND_PEEK_MISMATCH,                 -- USER_BIND_PEEK_MISMATCH VARCHAR2(1)
  TYPCHK_DEP_MISMATCH,                     -- TYPCHK_DEP_MISMATCH VARCHAR2(1)
  NO_TRIGGER_MISMATCH,                     -- NO_TRIGGER_MISMATCH VARCHAR2(1)
  FLASHBACK_CURSOR,                        -- FLASHBACK_CURSOR VARCHAR2(1)
  ANYDATA_TRANSFORMATION,                  -- ANYDATA_TRANSFORMATION VARCHAR2(1)
  INCOMPLETE_CURSOR,                       -- INCOMPLETE_CURSOR VARCHAR2(1)
  TOP_LEVEL_RPI_CURSOR,                    -- TOP_LEVEL_RPI_CURSOR VARCHAR2(1)
  DIFFERENT_LONG_LENGTH,                   -- DIFFERENT_LONG_LENGTH VARCHAR2(1)
  LOGICAL_STANDBY_APPLY,                   -- LOGICAL_STANDBY_APPLY VARCHAR2(1)
  DIFF_CALL_DURN,                          -- DIFF_CALL_DURN VARCHAR2(1)
  BIND_UACS_DIFF,                          -- BIND_UACS_DIFF VARCHAR2(1)
  PLSQL_CMP_SWITCHS_DIFF,                  -- PLSQL_CMP_SWITCHS_DIFF VARCHAR2(1)
  CURSOR_PARTS_MISMATCH,                   -- CURSOR_PARTS_MISMATCH VARCHAR2(1)
  STB_OBJECT_MISMATCH,                     -- STB_OBJECT_MISMATCH VARCHAR2(1)
  CROSSEDITION_TRIGGER_MISMATCH,           -- CROSSEDITION_TRIGGER_MISMATCH VARCHAR2(1)
  PQ_SLAVE_MISMATCH,                       -- PQ_SLAVE_MISMATCH VARCHAR2(1)
  TOP_LEVEL_DDL_MISMATCH,                  -- TOP_LEVEL_DDL_MISMATCH VARCHAR2(1)
  MULTI_PX_MISMATCH,                       -- MULTI_PX_MISMATCH VARCHAR2(1)
  BIND_PEEKED_PQ_MISMATCH,                 -- BIND_PEEKED_PQ_MISMATCH VARCHAR2(1)
  MV_REWRITE_MISMATCH,                     -- MV_REWRITE_MISMATCH VARCHAR2(1)
  ROLL_INVALID_MISMATCH,                   -- ROLL_INVALID_MISMATCH VARCHAR2(1)
  OPTIMIZER_MODE_MISMATCH,                 -- OPTIMIZER_MODE_MISMATCH VARCHAR2(1)
  PX_MISMATCH,                             -- PX_MISMATCH VARCHAR2(1)
  MV_STALEOBJ_MISMATCH,                    -- MV_STALEOBJ_MISMATCH VARCHAR2(1)
  FLASHBACK_TABLE_MISMATCH,                -- FLASHBACK_TABLE_MISMATCH VARCHAR2(1)
  LITREP_COMP_MISMATCH,                    -- LITREP_COMP_MISMATCH VARCHAR2(1)
  PLSQL_DEBUG,                             -- PLSQL_DEBUG VARCHAR2(1)
  LOAD_OPTIMIZER_STATS,                    -- LOAD_OPTIMIZER_STATS VARCHAR2(1)
  ACL_MISMATCH,                            -- ACL_MISMATCH VARCHAR2(1)
  FLASHBACK_ARCHIVE_MISMATCH,              -- FLASHBACK_ARCHIVE_MISMATCH VARCHAR2(1)
  LOCK_USER_SCHEMA_FAILED,                 -- LOCK_USER_SCHEMA_FAILED VARCHAR2(1)
  REMOTE_MAPPING_MISMATCH,                 -- REMOTE_MAPPING_MISMATCH VARCHAR2(1)
  LOAD_RUNTIME_HEAP_FAILED,                -- LOAD_RUNTIME_HEAP_FAILED VARCHAR2(1)
  HASH_MATCH_FAILED,                       -- HASH_MATCH_FAILED VARCHAR2(1)
  PURGED_CURSOR,                           -- PURGED_CURSOR VARCHAR2(1)
  BIND_LENGTH_UPGRADEABLE                  -- BIND_LENGTH_UPGRADEABLE VARCHAR2(1)
from
  GV$SQL_SHARED_CURSOR
where
  inst_id = USERENV('Instance')