select
  inst_id,                                 -- INST_ID NUMBER
  kglnaobj,                                -- SQL_TEXT VARCHAR2(1000)
  kglfnobj,                                -- SQL_FULLTEXT CLOB
  kglhdpar,                                -- ADDRESS RAW(8)
  kglobt46,                                -- HASH_VALUE NUMBER
  kglobt03,                                -- SQL_ID VARCHAR2(13)
  kglobt30,                                -- PLAN_HASH_VALUE NUMBER
  kglobccc,                                -- VERSION_COUNT NUMBER
  kglhdadr,                                -- LAST_ACTIVE_CHILD_ADDRESS RAW(8)
  kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6,-- SHARABLE_MEM NUMBER
  kglobt08+kglobt11,                       -- PERSISTENT_MEM NUMBER
  kglobt10,                                -- RUNTIME_MEM NUMBER
  kglobt01,                                -- SORTS NUMBER
  kglobclc,                                -- LOADED_VERSIONS NUMBER
  kglhdlmd,                                -- OPEN_VERSIONS NUMBER
  kglhdlkc,                                -- USERS_OPENING NUMBER
  kglobpc6,                                -- USERS_EXECUTING NUMBER
  kglobt04,                                -- FETCHES NUMBER
  kglobt05,                                -- EXECUTIONS NUMBER
  kglobt48,                                -- PX_SERVERS_EXECUTIONS NUMBER
  kglobt35,                                -- END_OF_FETCH_COUNT NUMBER
  kglhdldc,                                -- LOADS NUMBER
  kglnatim,                                -- FIRST_LOAD_TIME DATE
  kglobtt0,                                -- LAST_LOAD_TIME DATE
  kglobcla,                                -- LAST_ACTIVE_TIME DATE
  kglhdivc,                                -- INVALIDATIONS NUMBER
  kglobt12,                                -- PARSE_CALLS NUMBER
  kglobt13,                                -- DISK_READS NUMBER
  kglobwdw,                                -- DIRECT_WRITES NUMBER
  kglobt14,                                -- BUFFER_GETS NUMBER
  kglobt06,                                -- CPU_TIME NUMBER
  kglobt07,                                -- ELAPSED_TIME NUMBER
  kglobwap,                                -- APPLICATION_WAIT_TIME NUMBER
  kglobwcc,                                -- CONCURRENCY_WAIT_TIME NUMBER
  kglobwcl,                                -- CLUSTER_WAIT_TIME NUMBER
  kglobwui,                                -- USER_IO_WAIT_TIME NUMBER
  kglobt42,                                -- PLSQL_EXEC_TIME NUMBER
  kglobt43,                                -- JAVA_EXEC_TIME NUMBER
  kglobt15,                                -- ROWS_PROCESSED NUMBER
  kglobt02,                                -- COMMAND_TYPE NUMBER
  decode(                                  -- OPTIMIZER_MODE VARCHAR2(10)
    kglobt32, 0, 'NONE', 1, 'ALL_ROWS', 2, 'FIRST_ROWS', 3, 'RULE', 4, 'CHOOSE', 'UNKNOWN'),
  kglobtn0,                                -- OPTIMIZER_COST NUMBER
  kglobcce,                                -- OPTIMIZER_ENV RAW(2000)
  kglobcceh,                               -- OPTIMIZER_ENV_HASH_VALUE NUMBER
  kglobt17,                                -- PARSING_USER_ID NUMBER
  kglobt18,                                -- PARSING_SCHEMA_ID NUMBER
  kglobts4,                                -- PARSING_SCHEMA_NAME VARCHAR2(30)
  kglhdkmk,                                -- KEPT_VERSIONS NUMBER
  kglobts0,                                -- MODULE VARCHAR2(64)
  kglobt19,                                -- MODULE_HASH NUMBER
  kglobts1,                                -- ACTION VARCHAR2(64)
  kglobt20,                                -- ACTION_HASH NUMBER
  kglobt21,                                -- SERIALIZABLE_ABORTS NUMBER
  kglobts2,                                -- OUTLINE_CATEGORY VARCHAR2(64)
  decode(                                  -- OUTLINE_SID VARCHAR2(40)
    kglobt28, 0, NULL, kglobt28),
  decode(                                  -- REMOTE VARCHAR2(1)
    bitand(kglobt00,64),64, 'Y', 'N'),
  decode(                                  -- OBJECT_STATUS VARCHAR2(19)
    kglobsta, 1, 'VALID', 2, 'VALID_AUTH_ERROR', 3, 'VALID_COMPILE_ERROR', 4, 'VALID_UNAUTH', 5, 'INVALID_UNAUTH', 6, 'INVALID'),
  kglobt31,                                -- LITERAL_HASH_VALUE NUMBER
  kglobts3,                                -- SQL_PROFILE VARCHAR2(64)
  kglobt44,                                -- PROGRAM_ID NUMBER
  kglobt45,                                -- PROGRAM_LINE# NUMBER
  kglobt47,                                -- EXACT_MATCHING_SIGNATURE NUMBER
  kglobt49,                                -- FORCE_MATCHING_SIGNATURE NUMBER
  kglobcbca,                               -- BIND_DATA RAW(2000)
  kglobt22,                                -- TYPECHECK_MEM NUMBER
  kglobt52,                                -- IO_CELL_OFFLOAD_ELIGIBLE_BYTES NUMBER
  kglobt53,                                -- IO_INTERCONNECT_BYTES NUMBER
  kglobt54,                                -- PHYSICAL_READ_REQUESTS NUMBER
  kglobt55,                                -- PHYSICAL_READ_BYTES NUMBER
  kglobt56,                                -- PHYSICAL_WRITE_REQUESTS NUMBER
  kglobt57,                                -- PHYSICAL_WRITE_BYTES NUMBER
  kglobt58,                                -- OPTIMIZED_PHY_READ_REQUESTS NUMBER
  kglobt59,                                -- IO_CELL_UNCOMPRESSED_BYTES NUMBER
  kglobt53 - ((kglobt55+kglobt57) - kglobt52) -- IO_CELL_OFFLOAD_RETURNED_BYTES NUMBER
from
  x$kglcursor_child_sqlidph