select
  inst_id,                                 -- INST_ID NUMBER
  sid_knst,                                -- SID NUMBER
  serial_knst,                             -- SERIAL# NUMBER
  applynum_knstacr,                        -- APPLY# NUMBER
  applyname_knstacr,                       -- APPLY_NAME VARCHAR2(30)
  decode(                                  -- STATE VARCHAR2(21)
    state_knstacr,0,'INITIALIZING', 1,'APPLYING',2,'SHUTTING DOWN CLEANLY',3,'ABORTING',4,'IDLE'),
  total_applied_knstacr,                   -- TOTAL_APPLIED NUMBER
  total_waitdeps_knstacr,                  -- TOTAL_WAIT_DEPS NUMBER
  total_waitcommits_knstacr,               -- TOTAL_WAIT_COMMITS NUMBER
  total_admin_knstacr,                     -- TOTAL_ADMIN NUMBER
  total_assigned_knstacr,                  -- TOTAL_ASSIGNED NUMBER
  total_received_knstacr,                  -- TOTAL_RECEIVED NUMBER
  total_ignored_knstacr,                   -- TOTAL_IGNORED NUMBER
  total_rollbacks_knstacr,                 -- TOTAL_ROLLBACKS NUMBER
  total_errors_knstacr,                    -- TOTAL_ERRORS NUMBER
  unassigned_complete_knstacr,             -- UNASSIGNED_COMPLETE_TXNS NUMBER
  auto_txnbufsize_knstacr,                 -- AUTO_TXN_BUFFER_SIZE NUMBER
  lwm_time_knstacr,                        -- LWM_TIME DATE
  lwm_msg_num_knstacr,                     -- LWM_MESSAGE_NUMBER NUMBER
  lwm_msg_time_knstacr,                    -- LWM_MESSAGE_CREATE_TIME DATE
  hwm_time_knstacr,                        -- HWM_TIME DATE
  hwm_msg_num_knstacr,                     -- HWM_MESSAGE_NUMBER NUMBER
  hwm_msg_time_knstacr,                    -- HWM_MESSAGE_CREATE_TIME DATE
  startup_time_knstacr,                    -- STARTUP_TIME DATE
  elapsed_schedule_time_knstacr,           -- ELAPSED_SCHEDULE_TIME NUMBER
  elapsed_idle_time_knstacr,               -- ELAPSED_IDLE_TIME NUMBER
  lwm_position_knstacr,                    -- LWM_POSITION RAW(64)
  hwm_position_knstacr,                    -- HWM_POSITION RAW(64)
  processed_msg_num_knstacr                -- PROCESSED_MESSAGE_NUMBER NUMBER
from
  x$knstacr x
where
  type_knst=1 and exists (
  select
    1
  from
    v$session s
  where
    s.sid=x.sid_knst and s.serial#=x.serial_knst)