select
  inst_id,                                 -- INST_ID NUMBER
  reg_id,                                  -- REG_ID NUMBER
  num_ntfns,                               -- NUM_NTFNS NUMBER
  num_grouping_ntfns,                      -- NUM_GROUPING_NTFNS NUMBER
  num_ntfns_current_group,                 -- NUM_NTFNS_CURRENT_GROUP NUMBER
  last_ntfn_start_time,                    -- LAST_NTFN_START_TIME TIMESTAMP(3) WITH TIME ZONE
  last_ntfn_sent_time,                     -- LAST_NTFN_SENT_TIME TIMESTAMP(3) WITH TIME ZONE
  total_emon_latency,                      -- TOTAL_EMON_LATENCY NUMBER
  emon_server_id,                          -- EMON# NUMBER
  utl_raw.cast_from_number(all_emon_servers),-- ALL_EMON_SERVERS RAW(2000)
  total_payload_bytes_sent,                -- TOTAL_PAYLOAD_BYTES_SENT NUMBER
  num_retries,                             -- NUM_RETRIES NUMBER
  total_plsql_exec_time/1000000,           -- TOTAL_PLSQL_EXEC_TIME NUMBER
  last_err,                                -- LAST_ERR VARCHAR2(90)
  last_err_time,                           -- LAST_ERR_TIME TIMESTAMP(3) WITH TIME ZONE
  last_update_time,                        -- LAST_UPDATE_TIME TIMESTAMP(3) WITH TIME ZONE
  num_pending_ntfns                        -- NUM_PENDING_NTFNS NUMBER
from
  x$kkcnrstat