Monitor the progress of a sqlldr command

Does what it says on the tin !


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;

​A selection of topics on IT and its application to finance. 
​Send me your comments, questions ​or suggestions by clicking
h​ere


elmama