Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import time taking so long <<<===============================================================
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