Re: Import time taking so long

From: Satar <satar_at_my-dejanews.com>
Date: Thu, 25 Feb 1999 19:42:53 GMT
Message-ID: <7b493q$dt7$1@nnrp1.dejanews.com>

In article <36D1DBFA.6BB97BB1_at_toneline.n-o-s-p-a-m.demon.co.uk>, Steve Phelan <stevep_at_toneline.n-o-s-p-a-m.demon.co.uk> wrote:
> A Ustby wrote:
>
> > 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 ? Any other insight ?
>
> 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?

The higher this parameter is set, the number of sort runs are reduced (or even eliminated). The less times Oracle has to perform a sort run, the less times Oracle needs to write to disk, thus better performance. right?

Regards,
Satar
Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation."

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 13:42:53 CST