GV$BACKUP_SPFILE
select inst_id, -- INST_ID NUMBER birid, -- RECID NUMBER bistm, -- STAMP NUMBER bibss, -- SET_STAMP NUMBER bibsc, -- SET_COUNT NUMBER to_date -- MODIFICATION_TIME DATE (bimdt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), bifsz, -- BYTES NUMBER to_date -- COMPLETION_TIME DATE (bitsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') from x$kccbi

home |  up  |  mailbox