Re: Index creation taking days

The parallel option may hurt the performance if the data is not well distributed among disks. Since the parallel processes will cause disk contention.

Hope.

In article <6pltoh$oao$1_at_nnrp1.dejanews.com>,   syakobson_at_my-dejanews.com wrote:
> I do not know about Oracle 8, but in Oracle 7 I would increate init.ora
> parameter SORT_AREA_SIZE to the max.
>
> Solomon Yakobson.
>
> In article <6pjpm5$qi3$1_at_nnrp1.dejanews.com>,
> gplagge_at_hotmail.com wrote:
> > Hi, we are running Oracle 8.0.4 in an NT 4.0 environment.
> >
> > I am attempting to create an index (concatenated
> > on 2 columns) on a table with 16 million rows. So
> > far, it has been running for over 24 hours, and I
> > have 4 more to build! I am using the norecover and
> > parallel options
> >
> > The system is very quiet other than the one create
> > index command, and one select statement.
> > Thanks for any help.
> >
> > Gene Plagge
> > WorldxChange, Inc.
> > gplagge_at_hotmail.com
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 09:56:52 CDT