Re: Slooow Import

From: Sameer Utrankar <utrankas_at_coned.com>
Date: 1996/04/23
Message-ID: <4lj5ah$am6_at_ins3.coned.com>#1/1

>For faster import you could try these things:
>- make sure table does not have indexes before you start the import.
>If does, drop indexes, import the data and either let import to
>recreate indexes or create yourself after import.
>- set COMMIT=Y
>- increase BUFFER (try 1024000 for example) size
>- place import files on different physical disk than the datafiles are
>- if index creation is the problem, you could try increasing
>SORT_AREA_SIZE in init.ora.
>- import directly from disk if possible (vs. if you have exported to
>tape)
 

>By default COMMIT=N which means import will consume a lot of rollback
>size. Setting COMMIT=Y will commit the rows after each BUFFER size.

Commit=Y does not speed it up. In fact, it slows down import. Take a look at a paper in IOUW 96.

---

Utrankas_at_coned.com (Sameer Utrankar) Received on Tue Apr 23 1996 - 00:00:00 CEST