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?
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
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests