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 1213440 1165439   96.04 18/08/10 20:18:06 
480 18/08/10 20:14:42 486816  172329    35.39 18/08/10 20:23:50

Export

SQL>alter session set nls_date_format=’dd/mm/yy hh24:mi:ss’;
SQL>select sid, totalwork, sofar, round ((sofar/totalwork) * 100) done,start_time,sysdate + time_remaining/3600/24 end_at
from v$session_longops
where totalwork > sofar
and upper(message) like '%EXPORT%';
SID START_TIME TOTALWORK SOFA PER_DONE END_AT
———- —————– ———- ———- ———- —————– —————–
113 18/08/10 21:03:48 3864 892 23.08 18/08/10 21:33:21

Import

SQL>alter session set nls_date_format=’dd/mm/yy hh24:mi:ss’;
SQL>select sid, totalwork, sofar, round ((sofar/totalwork) * 100) per_done,start_time,sysdate + time_remaining/3600/24 end_at
from v$session_longops
where totalwork > sofar
and upper(message) like '%IMPORT%';
SID START_TIME TOTALWORK SOFAR PER_DONE END_AT
———- —————– ———- ———- ———- —————– —————–
121 19/08/10 11:02:54 3004
532 17.70 19/08/10 11:33:05

Leave Comment

Your email address will not be published. Required fields are marked *