What degree of parallelism are you using,
and how many indexes are you creating
concurrently ? Try one index at a time
running parallel 2 (for example).
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____England______January 21/23
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Christian Svensson wrote in message ...
>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
Received on Sun Nov 24 2002 - 04:20:18 CST
