Improving Speed of an Import 1

[Michael42]

Hello,

On a Solaris 8 system I have a large export file consisting of just one table but it has 6 million records. It takes 4+ hours to import. I can export it in 30 minutes primarily using DIRECT=Y and BUFFER=2000000.

What are some effective steps I can take to make this import go faster?

Adding more hardware is not a current option.

Thanks,

Michael42

 

[SantaMufasa]

Michael,

Imports always take longer than exports. The factor I use is 6 times longer. One possibility of speeding things up is to drop your indexes on the table and re-create them after the import is done. (That is why Oracle created the "indexfile=<filename>" as in imp parameter.) Be sure to also specify on your imp, "indexes=N" if you plan to re-create indexes after the imp.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Michael42]

SantaMufasa,

Thanks for your input. Perhaps user education can improve speed perception too, i.e. I want to make sure not to promise a time import miracle.

Actually, dropping the related indexes, constraints, PK AND triggers DID make a noticable increase in performance.

Thanks again,

Michael