import utility progress in oracle database

Started import of huge dump files (more than 20 gb each) in database, definitely it would take long time but wants to check progress of import utility in database. So I found below query explains fair enough details about the progress of import running.


set lines 180
col table_name for a50

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