1. Drop indexes, disable constraints, disable triggers. 2. Do not import indexes. 3. Turn off analyizing of objects. 4. Increase buffer size to about 5-10MB. More than that may not help. 5. Keep users out. 6. Turn off Archive log mode. 7. Do not use that feedback thingy. 8. Increase redo log sizes. Also check log_buffer size and increase it if is too small. 9. After import, build indexes with nologging turned on, w/ increased sort area sizes and proper TEMPORARY tablespace. 10. If still not fast enough, buy a bigger server and faster disks :)
Since you stated reorganization of the database, consider using LMTs, proper storage parameters (PCTFREE, PCTUSED) for tables etc. It will minimize the need for database reorganzations. HTH.. - Kirti -----Original Message----- Sent: Wednesday, February 13, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Hi How to make import fast except BUFFER size increase and big rollback segment if I am reorganising the database. Thanks -Seema _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Deshpande, Kirti 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).
