Tuesday, December 10, 2013

Script to monitor export/import status

EXPDP/IMPDP:
set lines 300
set pagesize 3000
COLUMN percent FORMAT 999.99
select sid "Session Id",sofar*8/1024/1024 "Completed Gb",TOTALWORK*8/1024/1024 "Total Size in Gb" ,ROUND(SOFAR/TOTALWORK*100,2) "Completed
%",time_remaining/60/60 "Expected Time in Hr" FROM V$SESSION_LONGOPS  WHERE OPNAME LIKE '%EXP%' AND OPNAME NOT LIKE '%aggregate%' AND
TOTALWORK !=0 AND SOFAR <> TOTALWORK;

No comments:

Post a Comment