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 /