可以查看导入导出的进度

set linesize 200 pagesize 50
column spid_sid_s# format A18 heading 'SPID,SID,SERIAL#'
column operation format A20 word_wrap
column progress format A13
column total format A15
column eta format A8
column message format A30 word_wrap
column username format A10
select c.spid || ',' || a.sid || ',' || a.serial# as spid_sid_s#,
       a.opname as operation,
       a.totalwork || ' ' || a.units as total,
       round(a.sofar/a.totalwork*100) || '% in ' || a.elapsed_seconds || 's' as progress,
       decode(a.sofar, 0, 'N/A', round(a.elapsed_seconds * (a.totalwork - a.sofar) / a.sofar / 60, 1) || 'm') as ETA,
       a.message,
       a.username
  from v$session_longops a,
       v$session b,
       v$process c
where a.sid = b.sid
   and a.serial# = b.serial#
   and b.paddr = c.addr
   and a.sofar < a.totalwork;