Import running slow

[Guest]

Hello

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
from sys.v_$sqlarea
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

Please explain

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?


Please suggest

[Tim...]

Hi.

Tables with lots of rows and large row sizes take longer than small tables. In addition index and constraint creation on these tables will be slower. That's about it really.

Cheers

Tim...

[Guest]

Hi Smita,

Check whether there are any triggers defined on the table.
Also check whether the table has lot of indexes.

Thanks
Prakash