Why import takes so long?

We are using the Oracle import utility. It appears the excess time is in the index build phase. Could this be affected (that much !) by the Oracle sort parm size ? Any other insight ?

Yes, it can. I've seen the build performance of indexes drop dramatically when sort areas are reduced. You'll see a much higher degree of temp tablespace activity.

Ans:

Not attacking you or anything, but how do you figuire that index creation performance (in this case) can be improved by reducing the SORT_AREA_SIZE parameter?

The higher this parameter is set, the number of sort runs are reduced (or even eliminated). The less times Oracle has to perform a sort run, the less times Oracle needs to write to disk, thus better performance. right?

Regards,
Satar
Oracle DBA/UNIX System Admin

Hosted by www.Geocities.ws