Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Monitoring import speed using imp
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 - 03:53:28 CDT