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: Index creation taking days

Re: Index creation taking days

From: <syakobson_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 01:26:41 GMT
Message-ID: <6pltoh$oao$1@nnrp1.dejanews.com>


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 Received on Tue Jul 28 1998 - 20:26:41 CDT

Original text of this message

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