select
  fn.inst_id,                              -- INST_ID NUMBER
  fn.fnnam,                                -- NAME VARCHAR2(513)
  fle.flelno,                              -- LOG# NUMBER
  fle.flethr,                              -- THREAD# NUMBER
  fle.fleseq,                              -- SEQUENCE# NUMBER
  fle.flenblks * fle.flebsz,               -- BYTES NUMBER
  to_number(fle.flelscn),                  -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    fle.fleltim, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') 
from
  x$kccfn fn,
  x$kccfle fle
where
  (fn.fntyp = 24) and (fn.fnnum = fle.flefnh) and (fle.fledup != 0)