select
  inst_id,                                 -- INST_ID NUMBER
  sid_knst,                                -- SID NUMBER
  serial_knst,                             -- SERIAL# NUMBER
  applynum_knstasl,                        -- APPLY# NUMBER
  applyname_knstasl,                       -- APPLY_NAME VARCHAR2(30)
  decode(                                  -- STATE VARCHAR2(36)
    state_knstasl,0,'IDLE',8,'DEQUEUE MESSAGES',10,'SCHEDULE MESSAGES',15,'INITIALIZING',16,'SPILLING',17,'PAUSED - WAITING FOR DDL TO COMPLETE'),
  total_msg_knstasl,                       -- TOTAL_MESSAGES_DEQUEUED NUMBER
  total_spill_msg_knstasl,                 -- TOTAL_MESSAGES_SPILLED NUMBER
  last_rcv_time_knstasl,                   -- DEQUEUE_TIME DATE
  last_rcv_msg_num_knstasl,                -- DEQUEUED_MESSAGE_NUMBER NUMBER
  last_rcv_msg_time_knstasl,               -- DEQUEUED_MESSAGE_CREATE_TIME DATE
  sga_used_knstasl,                        -- SGA_USED NUMBER
  elapsed_dequeue_time_knstasl,            -- ELAPSED_DEQUEUE_TIME NUMBER
  elapsed_schedule_time_knstasl,           -- ELAPSED_SCHEDULE_TIME NUMBER
  elapsed_spill_time_knstasl,              -- ELAPSED_SPILL_TIME NUMBER
  last_browse_num_knstasl,                 -- LAST_BROWSE_NUM NUMBER
  oldest_scn_num_knstasl,                  -- OLDEST_SCN_NUM NUMBER
  last_browse_seq_knstasl,                 -- LAST_BROWSE_SEQ NUMBER
  last_deq_seq_knstasl,                    -- LAST_DEQ_SEQ NUMBER
  oldest_xid_usn_knstasl,                  -- OLDEST_XIDUSN NUMBER
  oldest_xid_slt_knstasl,                  -- OLDEST_XIDSLT NUMBER
  oldest_xid_sqn_knstasl,                  -- OLDEST_XIDSQN NUMBER
  spill_lwm_scn_knstasl,                   -- SPILL_LWM_SCN NUMBER
  proxy_sid_knstasl,                       -- PROXY_SID NUMBER
  proxy_serial_knstasl,                    -- PROXY_SERIAL NUMBER
  proxy_spid_knstasl,                      -- PROXY_SPID VARCHAR2(12)
  (                                        -- CAPTURE_BYTES_RECEIVED NUMBER
  SELECT
    sesstat.ksusestv
  FROM
    x$ksusd stat,
    x$ksusesta sesstat,
    x$ksuse sess
  WHERE
    x.proxy_sid_knstasl=sesstat.ksusenum AND x.proxy_sid_knstasl=sess.indx AND x.proxy_serial_knstasl=sess.ksuseser AND bitand(sess.ksspaflg,1)!=0 AND bitand(sess.ksuseflg,1)!=0 AND sesstat.ksusestn = stat.indx AND bitand(sesstat.ksspaflg,1)!=0 AND bitand(sesstat.ksuseflg,1)!=0 AND sesstat.ksusestn<(
    select
      ksusgstl
    from
      x$ksusgif) AND stat.ksusdnam = 'bytes received via SQL*Net from client'),
  last_rcv_pos_knstasl,                    -- DEQUEUED_POSITION RAW(64)
  last_browse_pos_knstasl,                 -- LAST_BROWSE_POSITION RAW(64)
  oldest_pos_knstasl,                      -- OLDEST_POSITION RAW(64)
  spill_lwm_pos_knstasl,                   -- SPILL_LWM_POSITION RAW(64)
  oldest_xidtxt_knstasl                    -- OLDEST_TRANSACTION_ID VARCHAR2(128)
from
  x$knstasl x
where
  type_knst=7 and exists (
  select
    1
  from
    v$session s
  where
    s.sid=x.sid_knst and s.serial#=x.serial_knst)