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: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Sun, 28 Feb 1999 01:29:43 +0000
Message-ID: <u7lLNDAHwJ22EwHs@rwx777.demon.co.uk>


>> 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.
>>
>
>Steve,
>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?
>

I think he says performance will drop dramatically... --
Please remove nospam from my address to Reply. Received on Sat Feb 27 1999 - 19:29:43 CST

Original text of this message

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