I am running the import. Its taking very long time for a particular objects. Just tried to monitor the import process thru the following query (mentioned in this site - http://www.orafaq.com/faqiexp.htm
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
where sql_text like 'INSERT %INTO "%'
and command_type = 2
and open_versions > 0;
I am getting no rows selected for this
When I remove the condition "open_versions > 0", about 400 rows are returned, but rows_processed column is 0
I tries to look into the column details for this v$sqlarea view, but didnt understand
And whats could be the reason of such a slow import for some objects - ofcourse apart from the huge size of the import
Do I need to increase the rollback segments or their size?