select
  x$kcclh.inst_id,                         -- INST_ID NUMBER
  lhrid,                                   -- RECID NUMBER
  lhstm,                                   -- STAMP 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),                        -- NEXT_CHANGE# NUMBER
  to_number(lhrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    lhrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') 
from
  x$kcclh