Re: Import time taking so long <<<===============================================================

Eric,

    As a matter of preference, before I start an IMPORT I drop all indexes, then run scripts to re-create them after IMPORT completes. It is MUCHO faster to do it this way. BTW, use the PARALLEL option when re-creating your scripts.

Allan

Eric Junkermann wrote in message <36e6c708.8192059_at_news.demon.co.uk>...
>On Mon, 22 Feb 1999 13:56:45 GMT, alu_at_dairynet.com (A Ustby) wrote:
>
><snip>
>>We have the Oracle parameters (memory, sort area, etc) set
>>lower for the test instance. When we load production instance, it takes 17
>>hours. When we load the same data into the test instance, it takes 41
hours.
>>Both loads were done when the box was quiet.
>>
>>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 ?
>
>Yes, if you are having to do disk sorts when they would fit into memory on
>the other instance!
>
Received on Sun Mar 14 1999 - 10:53:02 CST