select
  inst_id,                                 -- INST_ID NUMBER
  key_keswxmon,                            -- KEY NUMBER
  case                                     -- STATUS VARCHAR2(19) status_keswxmon 
     when 1 
     then 'EXECUTING' 
     when 2 
     then 'DONE (ERROR)' 
     when 3 
     then 'DONE (FIRST N ROWS)' 
     when 4 
     then 'DONE (ALL ROWS)' 
     when 5 
     then 'DONE' 
     when 6 
     then 'FREED' 
     when 7 
     then 'QUEUED' 
     else 'UNKNOWN' end,
  decode(                                  -- USER# NUMBER
    pxsrvnum_keswxmon, 65535, userid_keswxmon , to_number(NULL)),
  decode(                                  -- USERNAME VARCHAR2(30)
    pxsrvnum_keswxmon, 65535, username_keswxmon, NULL),
  decode(                                  -- MODULE VARCHAR2(48)
    pxsrvnum_keswxmon, 65535, modulename_keswxmon, NULL),
  decode(                                  -- ACTION VARCHAR2(32)
    pxsrvnum_keswxmon, 65535, actionname_keswxmon, NULL),
  decode(                                  -- SERVICE_NAME VARCHAR2(64)
    pxsrvnum_keswxmon, 65535, svcname_keswxmon, NULL),
  decode(                                  -- CLIENT_IDENTIFIER VARCHAR2(64)
    pxsrvnum_keswxmon, 65535, clientid_keswxmon, NULL),
  decode(                                  -- CLIENT_INFO VARCHAR2(64)
    pxsrvnum_keswxmon, 65535, clientinfo_keswxmon, NULL),
  decode(                                  -- PROGRAM VARCHAR2(64)
    pxsrvnum_keswxmon, 65535, program_keswxmon, NULL),
  decode(                                  -- PLSQL_ENTRY_OBJECT_ID NUMBER
    pxsrvnum_keswxmon, 65535, decode(plsql_entry_oid_keswxmon, 0, to_number(null), plsql_entry_oid_keswxmon), NULL),
  decode(                                  -- PLSQL_ENTRY_SUBPROGRAM_ID NUMBER
    pxsrvnum_keswxmon, 65535, decode(plsql_entry_oid_keswxmon, 0, to_number(null), plsql_entry_subid_keswxmon), NULL),
  decode(                                  -- PLSQL_OBJECT_ID NUMBER
    pxsrvnum_keswxmon, 65535, decode(plsql_cur_oid_keswxmon, 0, to_number(null), plsql_cur_oid_keswxmon), NULL),
  decode(                                  -- PLSQL_SUBPROGRAM_ID NUMBER
    pxsrvnum_keswxmon, 65535, decode(plsql_cur_oid_keswxmon, 0, to_number(null), plsql_cur_subid_keswxmon), NULL),
  startmon_keswxmon,                       -- FIRST_REFRESH_TIME DATE
  lastpub_keswxmon,                        -- LAST_REFRESH_TIME DATE
  pubcount_keswxmon,                       -- REFRESH_COUNT NUMBER
  sid_keswxmon,                            -- SID NUMBER
  procname_keswxmon,                       -- PROCESS_NAME VARCHAR2(5)
  sqlid_keswxmon,                          -- SQL_ID VARCHAR2(13)
  decode(                                  -- SQL_TEXT VARCHAR2(2000)
    pxsrvnum_keswxmon, 65535, sqltext_keswxmon, NULL),
  decode(                                  -- IS_FULL_SQLTEXT VARCHAR2(1)
    pxsrvnum_keswxmon, 65535, decode(bitand(flags_keswxmon, 1), 0, 'N', 'Y'), NULL),
  execstart_keswxmon,                      -- SQL_EXEC_START DATE
  execid_keswxmon,                         -- SQL_EXEC_ID NUMBER
  planhash_keswxmon,                       -- SQL_PLAN_HASH_VALUE NUMBER
  exact_match_sig,                         -- EXACT_MATCHING_SIGNATURE NUMBER
  force_match_sig,                         -- FORCE_MATCHING_SIGNATURE NUMBER
  childaddr_keswxmon,                      -- SQL_CHILD_ADDRESS RAW(8)
  serial_keswxmon,                         -- SESSION_SERIAL# NUMBER
  decode(                                  -- PX_IS_CROSS_INSTANCE VARCHAR2(1)
    pxsrvnum_keswxmon, 65535, decode(bitand(flags_keswxmon, 2), 0, 'N', 'Y'), NULL),
  decode(                                  -- PX_MAXDOP NUMBER
    pxmaxdop, 0, to_number(NULL), pxmaxdop),
  decode(                                  -- PX_MAXDOP_INSTANCES NUMBER
    pxmaxdop_inst, 0, to_number(NULL), pxmaxdop_inst),
  decode(                                  -- PX_SERVERS_REQUESTED NUMBER
    pxtot_requested, 0, to_number(NULL), pxtot_requested),
  decode(                                  -- PX_SERVERS_ALLOCATED NUMBER
    pxtot_requested, 0, to_number(NULL), pxtot_allocated),
  decode(                                  -- PX_SERVER# NUMBER
    pxsrvnum_keswxmon, 65535, to_number(NULL), pxsrvnum_keswxmon),
  decode(                                  -- PX_SERVER_GROUP NUMBER
    pxsrvnum_keswxmon, 65535, to_number(NULL), pxsrvgrp_keswxmon),
  decode(                                  -- PX_SERVER_SET NUMBER
    pxsrvnum_keswxmon, 65535, to_number(NULL), pxsrvset_keswxmon),
  decode(                                  -- PX_QCINST_ID NUMBER
    pxsrvnum_keswxmon, 65535, to_number(NULL), pxqcinstid_keswxmon),
  decode(                                  -- PX_QCSID NUMBER
    pxsrvnum_keswxmon, 65535, to_number(NULL), pxqcsessid_keswxmon),
  decode(                                  -- ERROR_NUMBER VARCHAR2(40)
    error_code, 0, NULL, error_code),
  error_fac,                               -- ERROR_FACILITY VARCHAR2(4)
  error_msg,                               -- ERROR_MESSAGE VARCHAR2(256)
  binds_xml,                               -- BINDS_XML CLOB
  other_xml,                               -- OTHER_XML CLOB
  elapsed_time,                            -- ELAPSED_TIME NUMBER
  queuing_time_keswxmon,                   -- QUEUING_TIME NUMBER
  cpu_time,                                -- CPU_TIME NUMBER
  fetches,                                 -- FETCHES NUMBER
  buffer_gets,                             -- BUFFER_GETS NUMBER
  pread_reqs,                              -- DISK_READS NUMBER
  pwrite_reqs,                             -- DIRECT_WRITES NUMBER
  io_inter_bytes,                          -- IO_INTERCONNECT_BYTES NUMBER
  pread_reqs,                              -- PHYSICAL_READ_REQUESTS NUMBER
  pread_bytes,                             -- PHYSICAL_READ_BYTES NUMBER
  pwrite_reqs,                             -- PHYSICAL_WRITE_REQUESTS NUMBER
  pwrite_bytes,                            -- PHYSICAL_WRITE_BYTES NUMBER
  application_wait_time,                   -- APPLICATION_WAIT_TIME NUMBER
  concurrency_wait_time,                   -- CONCURRENCY_WAIT_TIME NUMBER
  cluster_wait_time,                       -- CLUSTER_WAIT_TIME NUMBER
  user_io_wait_time,                       -- USER_IO_WAIT_TIME NUMBER
  plsql_exec_time,                         -- PLSQL_EXEC_TIME NUMBER
  java_exec_time                           -- JAVA_EXEC_TIME NUMBER
from
  X$KESWXMON