set linesize 200
COLUMN table_name FORMAT a30 HEADING 'Table Name'
COLUMN rows_processed FORMAT 999,999,999 HEADING 'Rows processed'
COLUMN minutes FORMAT 999.99 HEADING 'Minutes'
COLUMN rows_per_minute FORMAT 999,999,999 HEADING 'Rows per minute'
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,2) 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
/