Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Monitoring import speed using imp

Monitoring import speed using imp

From: Wolfgang Zilgens <wzilgens_at_consem.de>
Date: Wed, 17 Oct 2001 10:53:28 +0200
Message-ID: <3bcd4738$0$182$4d4ebb8e@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 - 03:53:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US