select
  inst_id,                                 -- INST_ID NUMBER
  slnum,                                   -- GROUP# NUMBER
  decode(                                  -- DBID VARCHAR2(40)
    slpdb,0,'UNASSIGNED',to_number(slpdb)),
  slthr,                                   -- THREAD# NUMBER
  slseq,                                   -- SEQUENCE# NUMBER
  slsiz*slbsz,                             -- BYTES NUMBER
  slbsz,                                   -- BLOCKSIZE NUMBER
  decode(                                  -- USED NUMBER
    slnab, 0, 0, (slnab-1)*slbsz),
  decode(                                  -- ARCHIVED VARCHAR2(3)
    bitand(slflg,1),0,'NO','YES'),
  decode(                                  -- STATUS VARCHAR2(10)
    sign(slseq),0,'UNASSIGNED','ACTIVE'),
  to_number(sllos),                        -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    sllot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(slnxs),                        -- NEXT_CHANGE# NUMBER
  to_date(                                 -- NEXT_TIME DATE
    slnxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(slnxs),                        -- LAST_CHANGE# NUMBER
  to_date(                                 -- LAST_TIME DATE
    slnxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') 
from
  x$kccsl