Can one monitor how fast a table is imported?
If you need to monitor how fast rows are imported from a running import job, try one of the following methods: Method 1: 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_min from sys.v_$sqlarea where sql_text like ‘INSERT %INTO “%’ and command_type = 2 and open_versions > 0;For this to work one needs to be on Oracle 7.3 or higher (7.2 might also be OK). If the import has more than one table, this statement will only show information about the current table being imported. Contributed by Osvaldo Ancarola, Bs. As. Argentina. Method 2: Use the FEEDBACK=n import parameter. This command will tell IMP to display a dot for every N rows imported.
(for DBA If you need to monitor how fast rows are imported from a running import job, try one of the following methods: Method 1: 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_min from sys.v_$sqlarea where sql_text like ‘INSERT %INTO “%’ and command_type = 2 and open_versions > 0; For this to work one needs to be on Oracle 7.3 or higher (7.2 might also be OK). If the import has more than one table, this statement will only show information about the current table being imported. Contributed by Osvaldo Ancarola, Bs. As. Argentina. Method 2: Use the FEEDBACK=n import parameter. This command will tell IMP to display a dot for every N rows imported.
If you need to monitor how to display a dot for than one table, this statement will only show methods: Into “‘),30) table name, rows processed, round((sysdate-to date(first load time,’yyyy-mm-dd hh24: For this to work one fast rows are imported from being imported. Contributed by Osvaldo Ancarola , Bs. This parameter will tell Imp 7. If the import has more a running import job, try one of the following information about the current table needs to be on Oracle any N rows imported.
Can one modify data as it loads into the database? Let’s answer the first question “Can one monitor how fast a table is imported?” For each import using imp/impdp, you can specify to output a log file. The logfile contains all the information about the import including start time and end time of the import, but it does not provide timing for each individual table. The second question “Can one modify data as it loads into the database?” I assume that you are using Oracle utilities. If you are using imp/impdp, you cannot modify the data as it loads into the database. The other way to get around it is to use SQLLOADER. SQLLOADER will allow you to modify the data content as it loads into the database. But SQLLOADER will only read flat files. Hope it helps. If you have additional questions, please don’t hesitate to contact me.
