Import running slow

All posts relating to Oracle database administration.

Moderator: Tim...


Import running slow

Postby Guest » Mon Nov 01, 2004 6:09 pm


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 -

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

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:Import running slow

Postby Tim... » Mon Nov 01, 2004 6:09 pm


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.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:


RE:Import running slow

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hi Smita,

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest