RE: Speed up import of a 10gb table with a long_raw datatype
You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: Speed up import of a 10gb table with a long_raw datatype
Increase buffer to maximum possible may be 104857600(100MB). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 21 Feb 2001 08:06:43 -0800 DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Speed up import of a 10gb table with a long_raw datatype
Thanks Lee, What is the impst command? I'm not familiar with it. ...JIM... [EMAIL PROTECTED] 2/21/01 10:21:01 AM You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: James Howerton 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: Speed up import of a 10gb table with a long_raw datatype
Single stream import. I have noticed significant gains in the past when using this but to be honest I haven't yet used it on an Oracle 8 database (someone else out there may be able to say if it still performs). Go to $ORACLE_HOME/rdbms/lib and type make -f ins_rdbms.mk impst if this doesn't work ( as it didn't for me) with errors on "Can't locate file for: -lndw1" do the following make -f ins_rdbms.mk impst LLIBOWSUTL="" Move the executable into $ORACLE_HOME/bin and use as per the imp command. This also works for export, merely substitute all occurences of impst above with expst. Hope this helps. Regards Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:51 To: Multiple recipients of list ORACLE-L Thanks Lee, What is the impst command? I'm not familiar with it. ...JIM... [EMAIL PROTECTED] 2/21/01 10:21:01 AM You could up your buffer size and also use impst. Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: James Howerton 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: lerobe - Lee Robertson 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: Speed up import of a 10gb table with a long_raw datatype
It is a imp linked single task: make -f ins_rdbms.mk impst. In this case, you don't go through the listener. Regards. -Mensaje original- De: James Howerton [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de febrero de 2001 17:51 Para: Multiple recipients of list ORACLE-L Asunto: RE: Speed up import of a 10gb table with a long_raw datatype Thanks Lee, What is the impst command? I'm not familiar with it. ...JIM... [EMAIL PROTECTED] 2/21/01 10:21:01 AM You could up your buffer size and also use impst. Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] -Original Message- Sent: 21 February 2001 16:07 To: Multiple recipients of list ORACLE-L DBA's, Does anyone have any tips for speeding up the import of a 10gb table with a long_raw datatype. I've disabled the constraints, dropped the indexes, put the database in noarchivelog mode. My import parameters are: file=/TEMP_MOUNT/imp_cflo/cfuabprd_blob.dmp log=cfuabprd_blob.log fromuser=x touser=xx tables=REPORT_BLOBT indexes=N rows=Y constraints=N feedback=1000 buffer=200 ignore=Y commit=Y Hardware: Sun E10K 4cpu's 3gb ram OS: solaris2.6 Oracle:8.1.6.2.1 TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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 information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: James Howerton 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: Trassens, Christian 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).