Oracle – Table Import Progress

Posted by 

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;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;
 
 
 
 Select
 a.sid,
 a.serial#,
 b.status,
 a.opname,
 to_char(a.START_TIME,' dd-Mon-YYYY HH24:mi:ss') START_TIME,
 to_char(a.LAST_UPDATE_TIME,' dd-Mon-YYYY HH24:mi:ss') LAST_UPDATE_TIME,
 a.time_remaining as "Time Remaining Sec" ,
 a.time_remaining/60 as "Time Remaining Min",
 a.time_remaining/60/60 as "Time Remaining HR"
 From v$session_longops a, v$session b
 where a.sid = b.sid
 And time_remaining > 0