Srinivas,
Do you have any indexes, constraints, triggers on this table
When trying to import.
Cause this can reduce import performance substantially.
Just to let you know, on a DELL 6450 Windoze NT Server, I get can import 2
million records per minute as long as there are no indexes or constraints
present.
Depending on the size of your server and disk speeds you should be able to
achieve good performance as long there are no indexes, constraints.
For large tables it is better to drop the indexes, constraints.
Import the data and then rebuild the indexes and enable constraints.
Make sure there is no contention for disk io between dump file and
datafiles.
Use commit=n ,make sure you have a large rollback segment online eg. BIGR.
Switch smaller rollback segments offline.
I use this useful script from Frank Naude's Orafaq.
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;
This tells me how far the import is gone.
Regards
Suhen
Hi lists,
I have a tablespace that is 600 M size, has 4 million rows.
It is taking nearly 2 hrs to finish the import.
In the meantime, I tried selecting howmany rows imported(from another
session), but every time I issue query,the result is zero.
But after finishing the import I got the total count.
Is there anyway to see how may rows imported in that table(in the middle
or import process, from another session) ?
thnx in adv.
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suhen Pather
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
