Monitoring import speed using imp
Date: Wed, 17 Oct 2001 10:53:28 +0200
Message-ID: <3bcd4738$0$182$4d4ebb8e_at_read.news.de.uu.net>
I used the following sql to monitor the import speed of the imp tool. (before you start flush the shared pool)
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_minute
from
sys.v_$sqlarea
where
sql_text like 'INSERT %INTO "%'
and
command_type = 2
and
open_versions > 0
/
but after a while this happens: the statistics of one import resets to zero (Rows_per_minute) while the import is still going on what happened with the table v$sql_area
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DELL" ("DELL_CD_LOC_KEY_ 720874 2,9 245752
INTO "TRAN" ("TRAN_KEY_DB", "T 2395440 67,4 35558
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DELL" ("DELL_CD_LOC_KEY_ 65534 3,7 17954
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DELL" ("DELL_CD_LOC_KEY_ 131068 3,8 34643
INTO "TRAN" ("TRAN_KEY_DB", "T 0 68,2 0
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DELL" ("DELL_CD_LOC_KEY_ 753641 5,7 132995
INTO "TRAN" ("TRAN_KEY_DB", "T 26616 70,1 379
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DELL" ("DELL_CD_LOC_KEY_ 884709 6,1 145831
INTO "TRAN" ("TRAN_KEY_DB", "T 26616 70,5 377
Received on Wed Oct 17 2001 - 10:53:28 CEST