Monitor and Modify Data during Loading

How to monitor how fast a table is imported? How to modify data as it loads into the database?

shanthiavari
Profile Answers by shanthiavari Questions by shanthiavari
Jun 10th, 2008
3
2195

Showing Answers 1 - 3 of 3 Answers

Ramshankardba
Profile Answers by Ramshankardba

Jan 17th, 2009

Use below script to monitor how speed import is happening.
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;