Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import time taking so long <<<===============================================================

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

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Wed, 10 Mar 1999 19:27:03 GMT
Message-ID: <36e6c708.8192059@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 Wed Mar 10 1999 - 13:27:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US