GV$OFFLINE_RANGE definition in Oracle Database 11.2
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