RE: IMPORT TIME IS HIGH

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Fri, 21 Dec 2001 08:54:22 -0800
Message-ID: <F001.003E1D4E.20011221083522@fatcity.com>

Everyone needs to remember that the Oracle Import Utility is just a 3GL "C" program with INSERT statements. It is widely publicized that the ratio is 1:4 so this should not come as a surprise to anyone. Some ways to improve performance is to use a large buffer size (10-20M) and set COMMIT=Y to facilitate array inserts. There are OS options for improving the I/O bandwidth on the file, but that's really it.

Rachel is correct. She did not want to frighten anyone. Now the good news is with Oracle9i, Oracle has added Array Inserts to the tool so this may help. How many of us remember when Oracle claimed that EXP/IMP were to go away in 8i????

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

 -----Original Message-----
Sent: Friday, December 21, 2001 10:25 AM

To:     Multiple recipients of list ORACLE-L
Subject:        Re: IMPORT TIME IS HIGH

well, yeah, depending on the number of indexes, I've seen a 6 hour export take almost 24 hours to import -- on the same box as the export was done.

I was trying not to frighten anyone :)

• Stephane Faroult <sfaroult_at_oriole.com> wrote:
  > Rachel Carmichael wrote:
  > >
  > > in addition, define what you mean by "much time" -- how much data
  > are
  > > you loading? how slow is the load actually? I've found that in
  > > general, an import takes about twice as long as the export.
  > >
  >
  > Rachel, I don't know it's because of the festive season but I find
  > you
  > optimistic. I'd rather say 3 or 4 times as long as a conventional
  > export.
  > --
  > Regards,
  >
  > Stephane Faroult
  > Oriole Ltd
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Stephane Faroult
  > INET: sfaroult_at_oriole.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).
  

  ---

Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.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).

Received on Fri Dec 21 2001 - 10:54:22 CST