查看import進度

select substr(sql_text,instr(sql_text,'INTO "'),30) table_name,
rows_processed,
round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,
trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi: ss'))*24*60)) rows_per_min
from sys.v_$sqlarea
where sql_text like 'INSERT %INTO "%'
and command_type = 2
and open_versions > 0;

此附件為 imp utility 於import 時可看到

http://forums.oracle.com/forums/thread.jspa?messageID=6495966&tstart=0

select substr(sql_text,instr(sql_text,'INTO "'),30) table_name,

 rows_processed,

 round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,

 trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi: ss'))*24*60)) rows_per_min

 from sys.v_$sqlarea

 where sql_text like 'INSERT %INTO "%'

 and command_type = 2

 and open_versions > 0;