Re: Parallel option with create index - newbie

Christian Svensson wrote:
>
> Greetings,
>
> When creating our 9 Bitmap indexes on a partitioned ~22Gb table with
> ~130 million of rows, we are using a parallel hint in the creation
> script.
>
> We can see that the server is completely exhausted when the indexes
> are created, we can see a idle time of 0-3% when running top.
>
> Env:
> Sun Solaris 6(!) (to be upgraded soon, dont blame me...)
> Oracle 8.1.7
> 4 cpu and 8Gb ram
>
> My question is how can we still use the parallel hint, but not
> completely exhaust the server.
>
> Thanks to any tips.
>
> Regards.
>
> Christian

parallel by definition is basically a "grab as much resource as I can" mechanism. You might get some joy with resource manager to lower that sessions ability to consume the machine, but I doubt it.

You could shift the cpu load to disk by articifically dropping the various ...size init.ora params, but I think thats a step backward not forward.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."