select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  FILE#,                                   -- FILE# NUMBER
  OFFLINE_CHANGE#,                         -- OFFLINE_CHANGE# NUMBER
  ONLINE_CHANGE#,                          -- ONLINE_CHANGE# NUMBER
  ONLINE_TIME,                             -- ONLINE_TIME DATE
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME                           -- RESETLOGS_TIME DATE
from
  GV$OFFLINE_RANGE
where
  inst_id = USERENV('Instance')