GV$OFFLINE_RANGE
select 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') from x$kccor

home |  up  |  mailbox