GV$OFFLINE_RANGE

select
x$kccor.inst_id,         -- INST_ID NUMBER
orrid,                   -- RECID NUMBER
orstm,                   -- STAMP NUMBER
ordfp,                   -- FILE# NUMBER
to_number (orofs),       -- OFFLINE_CHANGE# NUMBER
to_number (orons),       -- ONLINE_CHANGE# NUMBER
to_date                  -- ONLINE_TIME DATE
  (oront, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (orrls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (orrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') 
from
x$kccor
home |  up  |  mailbox