RE: count rows that are being imported

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Mon, 01 Oct 2001 21:44:36 -0700
Message-ID: <F001.0039E4E4.20011001215519@fatcity.com>

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: Shrinivas.Tatireddy_at_med.ge.com

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: ListGuru_at_fatcity.com (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: Suhen.Pather_at_strandbags.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------