查看oracle长时间运行任务的进度

查看oracle长时间运行任务的进度：可以是导入导出，也可以是rman备份

SELECT SID, SERIAL#,opname, to_char(start_time,'yyyy-mm-dd HH24:MI:SS')  start_time, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%COMPLETE",ceil(ELAPSED_SECONDS/60) ELAPSED_MI
FROM V$SESSION_LONGOPS where SOFAR<>TOTALWORK order by start_time asc;

复制