Buffer in Import
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=5 --- is that 5 bytes, or 5 rows TIA Ramon
Re: Buffer in Import
I believe that it refers to bytes. --- Ramon E. Estevez [EMAIL PROTECTED] 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=5 --- is that 5 bytes, or 5 rows TIA Ramon = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ 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: [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).
RE: Buffer in Import
Thanks for clarify me. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hately MikeSent: Thursday, 25 April, 2002 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Buffer in Import It's bytes. Regards, Mike Hately -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: 25 April 2002 15:39To: Multiple recipients of list ORACLE-LSubject: Buffer in Import 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=5 --- is that 5 bytes, or 5 rows TIA Ramon This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
RE: Buffer in Import
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: [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 04/25/02 12:03PM I believe that it refers to bytes. --- Ramon E. Estevez [EMAIL PROTECTED] 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=5 --- is that 5 bytes, or 5 rows TIA Ramon = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ 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: [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: Gene Sais 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). 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: [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).
RE: Buffer in Import
Title: RE: Buffer in Import Ramon, Bytes. IMHO, 5 is way to low if you have a lot of data to import. Try doubling it at least. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]] 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=5 --- is that 5 bytes, or 5 rows TIA Ramon
RE: Buffer in Import
Thanks Stephen and all that reply. Now I am clear Tks -Original Message- Stephen Sent: Thursday, 25 April, 2002 1:09 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 04/25/02 12:03PM I believe that it refers to bytes. --- Ramon E. Estevez [EMAIL PROTECTED] 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=5 --- is that 5 bytes, or 5 rows TIA Ramon = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ 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: [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: Gene Sais 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). 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: [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: Ramon E. Estevez 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).