Monitor import running

March 2nd, 2012
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
/
Comments are closed.