SELECT
  INST_ID,                                 -- INST_ID NUMBER
  EID_KPONESTAT,                           -- EMON# NUMBER
  SID_KPONESTAT,                           -- SID NUMBER
  START_KPONESTAT,                         -- STARTUP_TIME TIMESTAMP(3) WITH TIME ZONE
  DECODE(                                  -- SERVER_TYPE VARCHAR2(8)
    QOS_KPONESTAT,0,'REGULAR','RELIABLE'),
  DECODE(                                  -- STATUS VARCHAR2(6)
    STATUS_KPONESTAT,0,'IDLE','ACTIVE'),
  SCT_KPONESTAT,                           -- STATUS_CHANGE_TIME TIMESTAMP(3) WITH TIME ZONE
  NTFN_KPONESTAT,                          -- NUM_NTFNS NUMBER
  GRPNTFN_KPONESTAT,                       -- NUM_GROUPING_NTFNS NUMBER
  INGRPNTFN_KPONESTAT,                     -- NUM_NTFNS_ALL_GROUPS NUMBER
  NUMOCI_KPONESTAT,                        -- NUM_OCI_NTFNS NUMBER
  NUMPLS_KPONESTAT,                        -- NUM_PLSQL_NTFNS NUMBER
  NUMEML_KPONESTAT,                        -- NUM_EMAIL_NTFNS NUMBER
  NUMHTP_KPONESTAT,                        -- NUM_HTTP_NTFNS NUMBER
  POSTSPROC_KPONESTAT,                     -- NUM_EVENTS_PROCESSED NUMBER
  POSTSPEND_KPONESTAT,                     -- NUM_EVENTS_PENDING NUMBER
  NUMANON_KPONESTAT,                       -- NUM_ANONYMOUS_NTFNS NUMBER
  NUMAQ_KPONESTAT,                         -- NUM_AQ_NTFNS NUMBER
  NUMDBC_KPONESTAT,                        -- NUM_DBCHANGE_NTFNS NUMBER
  ANONTIME_KPONESTAT/1000000,              -- TOTAL_ANONYMOUS_NTFN_TIME NUMBER
  AQTIME_KPONESTAT/1000000,                -- TOTAL_AQ_NTFN_TIME NUMBER
  DBCTIME_KPONESTAT/1000000,               -- TOTAL_DBCHANGE_NTFN_TIME NUMBER
  PLSTIME_KPONESTAT/1000000,               -- TOTAL_PLSQL_NTFN_TIME NUMBER
  OCITIME_KPONESTAT/1000000,               -- TOTAL_OCI_NTFN_TIME NUMBER
  EMLTIME_KPONESTAT/1000000,               -- TOTAL_EMAIL_NTFN_TIME NUMBER
  HTPTIME_KPONESTAT/1000000,               -- TOTAL_HTTP_NTFN_TIME NUMBER
  EMONLAT_KPONESTAT,                       -- TOTAL_EMON_LATENCY NUMBER
  REGEXP_KPONESTAT,                        -- REGISTRATIONS_EXPIRED NUMBER
  REGPRG_KPONESTAT,                        -- REGISTRATIONS_PURGED NUMBER
  REGINV_KPONESTAT,                        -- REGISTRATIONS_INVALID NUMBER
  LUT_KPONESTAT                            -- LAST_UPDATE_TIME TIMESTAMP(3) WITH TIME ZONE
FROM
  X$KPONESTAT