In how much time will RMAN or Datapump finish the job?
This is how you can see it: RMAN SQL>alter session set nls_date_format=’dd/mm/yy hh24:mi:ss’; SQL>select sid, totalwork, sofar,(sofar/totalwork) * 100 per_done,start_time, sysdate + time_remaining/3600/24 end_at from v$session_longops where totalwork > sofar and lower(opname) not like ‘%aggregate%’ and lower(opname) like ‘rman%’; SID START_TIME TOTALWORK SOFAR PER_DONE END_AT —– —————– ———- ———- ———- —————– —————– 491 18/08/10 20:13:45…
