select
  inst_id,                                 -- INST_ID NUMBER
  kglnaobj,                                -- SQL_TEXT VARCHAR2(1000)
  kglfnobj,                                -- SQL_FULLTEXT CLOB
  kglobt03,                                -- SQL_ID VARCHAR2(13)
  kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6+kglobt16,-- SHARABLE_MEM NUMBER
  kglobt08+kglobt11,                       -- PERSISTENT_MEM NUMBER
  kglobt10,                                -- RUNTIME_MEM NUMBER
  kglobt01,                                -- SORTS NUMBER
  decode(kglobhs6,0,0,1),                  -- LOADED_VERSIONS NUMBER
  decode(kglhdlmd,0,0,1),                  -- OPEN_VERSIONS NUMBER
  kglhdlkc,                                -- USERS_OPENING NUMBER
  kglobt04,                                -- FETCHES NUMBER
  kglobt05,                                -- EXECUTIONS NUMBER
  kglobt48,                                -- PX_SERVERS_EXECUTIONS NUMBER
  kglobt35,                                -- END_OF_FETCH_COUNT NUMBER
  kglobpc6,                                -- USERS_EXECUTING NUMBER
  kglhdldc,                                -- LOADS NUMBER
  substr(                                  -- FIRST_LOAD_TIME VARCHAR2(19)
    to_char(kglnatim,'YYYY-MM-DD/HH24:MI:SS'),1,19),
  kglhdivc,                                -- INVALIDATIONS NUMBER
  kglobt12,                                -- PARSE_CALLS NUMBER
  kglobt13,                                -- DISK_READS NUMBER
  kglobwdw,                                -- DIRECT_WRITES NUMBER
  kglobt14,                                -- BUFFER_GETS 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
  kglhdpar,                                -- ADDRESS RAW(8)
  kglobtp0,                                -- TYPE_CHK_HEAP RAW(8)
  kglnahsh,                                -- HASH_VALUE NUMBER
  kglobt46,                                -- OLD_HASH_VALUE NUMBER
  kglobt30,                                -- PLAN_HASH_VALUE NUMBER
  kglobt09,                                -- CHILD_NUMBER NUMBER
  kglobts5,                                -- SERVICE VARCHAR2(64)
  kglobt48,                                -- SERVICE_HASH 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)
  kglobt06,                                -- CPU_TIME NUMBER
  kglobt07,                                -- ELAPSED_TIME NUMBER
  decode(                                  -- OUTLINE_SID NUMBER
    kglobt28, 0, to_number(NULL), kglobt28),
  kglhdadr,                                -- CHILD_ADDRESS RAW(8)
  kglobt29,                                -- SQLTYPE NUMBER
  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
  substr(                                  -- LAST_LOAD_TIME VARCHAR2(19)
    to_char(kglobtt0,'YYYY-MM-DD/HH24:MI:SS'),1,19),
  decode(kglobt33, 1, 'Y', 'N'),           -- IS_OBSOLETE VARCHAR2(1)
  decode(                                  -- IS_BIND_SENSITIVE VARCHAR2(1)
    bitand(kglobacs, 1), 1, 'Y', 'N'),
  decode(                                  -- IS_BIND_AWARE VARCHAR2(1)
    bitand(kglobacs, 2), 2, 'Y', 'N'),
  decode(                                  -- IS_SHAREABLE VARCHAR2(1)
    bitand(kglobacs, 4), 4, 'Y', 'N'),
  kglhdclt,                                -- CHILD_LATCH NUMBER
  kglobts3,                                -- SQL_PROFILE VARCHAR2(64)
  kglobts7,                                -- SQL_PATCH VARCHAR2(30)
  kglobts6,                                -- SQL_PLAN_BASELINE VARCHAR2(30)
  kglobt44,                                -- PROGRAM_ID NUMBER
  kglobt45,                                -- PROGRAM_LINE# NUMBER
  kglobt47,                                -- EXACT_MATCHING_SIGNATURE NUMBER
  kglobt49,                                -- FORCE_MATCHING_SIGNATURE NUMBER
  kglobcla,                                -- LAST_ACTIVE_TIME DATE
  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
  kglobt23,                                -- LOCKED_TOTAL NUMBER
  kglobt24,                                -- PINNED_TOTAL NUMBER
  kglobt59,                                -- IO_CELL_UNCOMPRESSED_BYTES NUMBER
  kglobt53 - ((kglobt55+kglobt57) - kglobt52) -- IO_CELL_OFFLOAD_RETURNED_BYTES NUMBER
from
  x$kglcursor_child