select
  inst_id,                                 -- INST_ID NUMBER
  lhthp,                                   -- THREAD# NUMBER
  lhseq,                                   -- SEQUENCE# NUMBER
  to_number(lhlos),                        -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    lhlot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(lhnxs)                         -- SWITCH_CHANGE# NUMBER
from
  x$kcclh