Re: Index creation taking too long

From: mdevreese <mdevreese_at_roularta.be>
Date: Wed, 08 Jul 1998 11:54:23 +0200
Message-ID: <35A341CF.7D76@roularta.be>

Lisa Lewis wrote:
>
> I am creating a non-unique index on a table with roughly 3 million entries.
> I am using the nologging option. The index creation took 30 minutes...much
> longer than I had expected. I am trying to determine why it took so long.
> I am currently the only user of this development database. I am running on
> Solaris. When I do a vmstat 5 5, I see that I am paging somewhat (pi=274
> po=200 roughly). Is this bad? What can I do to improve the speed of
> creating the index? Any suggestions would be greatly appreciated!!!
>
> Lisa
> P.S. Please respond by e-mail

Try creating the index with the parallel option, this means that Oracle will use more CPU power.

Example : create index ... parallel 4 means that Oracle will use the 4 CPU's to create the index, of course this will only work if you have 4 CPU's. Received on Wed Jul 08 1998 - 04:54:23 CDT