Oracle: Progress of running import

2009 June 17
tags: Databases
by Josh Hand

I found the following query a while ago for displaying the progress of a running import, I thought it might useful to someone else so I thought I'd post it up.

--Progress of running 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;

No Responses leave one →

Leave a Reply