Post date: 01-Jun-2009 10:21:41
column operation format a80
column "PCT DONE" format a10 just l
set lines 300 pages 300
SELECT SID,
MESSAGE OPERATION,
ROUND(SOFAR * 8192 / 1024 / 1024,2) "Done[MB]",
ROUND(TOTALWORK * 8192 / 1024 / 1024,2) "Total[MB]",
ROUND(SOFAR / TOTALWORK * 100,1)
||'%' "PCT DONE"
FROM V$SESSION_LONGOPS
WHERE SOFAR <> TOTALWORK
AND TOTALWORK <> 0
ORDER BY 1;