RE: HOW TO MAKE FAST EXPORT

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 13 Feb 2002 19:49:11 -0800
Message-ID: <F001.0040F008.20020213193319@fatcity.com>

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: oracledbam_at_hotmail.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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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 Wed Feb 13 2002 - 21:49:11 CST