Re: Import Utiltiy

To improve the performance of import there are a number of things you can do.

1. If you are on a multi proc machine split the import into multi streams by user.
2. If you are importing indexes increase the sort_area_size to as large as you can as this will reduce the amount of time it takes to build the index.
3. Compile up the impst (single task executable for import), gives about 20% performance gain. I think the command is make -f rdbms.in?? impst
4. disable redo logging activity (not supported) _disable_logging=true

Rgds,

Phil

Alianto <alianto_at_mincom.co.id> wrote in article <36b92366.0_at_news1.ibm.net>...
> Most of our client use Oracle 7.x.x database running under HP 9000.
> We usually refresh data from one machine to another machine, and so far
we
> didn't any problem with export/import utility.
>
> I have some questions about import utility :
> 1. How to increase import performance ?
> 2. Where can I find some information that will increase import
performance ?
>
> Thanks,
>
> Alianto
>
>
>
Received on Thu Feb 04 1999 - 06:56:09 CST