Oracle-L: RE: Buffer in Import

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 25 Apr 2002 10:08:37 -0800
Message-ID: <F001.0044FAE9.20020425100837@fatcity.com>

The buffer size refers to the number of bytes placed into Imports internal buffer. Generally, you should make this value large, like 5 or 10m to accommodate large data imports. Small values increase import time and induce risk for large tables.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Thursday, April 25, 2002 12:59 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Buffer in Import

I 2nd that, bytes.

>>> treegarden_at_yahoo.com 04/25/02 12:03PM >>> I believe that it refers to bytes.

"Ramon E. Estevez" <com.banilejas_at_codetel.net.do> wrote:
> Does the parameter buffer in the import refers to bytes or number of
> rows ?
>
> Kind of confuse. I think it refers to the number of rows.
>
> buffer=50000 ---> is that 50000 bytes, or 50000 rows
>
> TIA
>
> Ramon
>
>
>
>

Paul Baumgartel, Adept Computer Associates, Inc. paul.baumgartel_at_aya.yale.edu

Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: treegarden_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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
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 Thu Apr 25 2002 - 13:08:37 CDT