Completion time of RMAN / Data Pump


For 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 01/12/13 20:13:45 1213440 1165439 96.04 01/12/13 20:18:06
480 01/12/13 20:14:42 486816 172329 35.39 01/12/13 20:23:50

For 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 SOFAR PER_DONE END_AT
———- —————– ———- ———- ———- —————– —————–
113 01/12/13 21:03:48 3864 892 23.08 01/12/13 21:33:21

For 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 01/12/13 11:02:54 3004 532 17.70 01/12/13 11:33:05

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: