Oracle: monitor import session

Importing data from one database to another is a useful feature in oracle. But this takes time so its a good thing to know you progress.Here is a cool script that you can use to monitor your import session:

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_minute
FROM
sys.v_$sqlarea
WHERE
sql_text like 'INSERT %INTO "%'
AND command_type = 2
AND open_versions > 0;

I know that i have not yet written about how to use the export and import in oracle(i will be explaining it very soon). But for guys who already using the import method this might be helpful .=ELK=