Re: Index creation taking days

From: Guus van de Sande <dyntas.nospam_at_wxs.nl>
Date: 28 Jul 1998 19:54:26 GMT
Message-ID: <01bdba61$60764680$5b4f79c3@dyntaswxs.nl>

in addition to the other good suggestions:

-check the size of you redo logfiles (they should be at least 5M) - is the INDEX located in a tablespace on another disk ? You might have a disk-contention problem.
(the same for the redo-log files, don't put them on the same disk as data or index tablespaces.

regards,

Guus van de Sande

--
- remove NOSPAM from my e-mail adress -

gplagge_at_hotmail.com schreef in artikel <6pjpm5$qi3$1_at_nnrp1.dejanews.com>...
> 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
>
Received on Tue Jul 28 1998 - 14:54:26 CDT