Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to make Oracle use all CPUs on SUN
Look up parallel query in the docs. (not parallel server, parallel query)
Jim
"Frank Y" <dmx_frank_at_yahoo.com> wrote in message
news:9d599275.0210260922.5d75721c_at_posting.google.com...
> Hi all,
>
> Background information:
> SUNFire 450 server with 4 CPUs,2GB RAM
> Solaris 2.8
> Oracle 8.1.7 with typical installation.
>
> I have a query join on four table with a lot of extenal procedure
> calls (some computational work for each row of data).
> When I execute this query, the first CPU will be 100% used, and other
> user's query will be 4 times slower than before. But other CPUs
> remain very low(below 10 %) utilization. It seems Oracle only use one
> CPU to process all queries.
>
> I wonder how can make Oracle use all 4 CPUs resource. Is there any
> configuration in Oracle must be set? Or any thing can be done at OS
> level?
>
> Thanks very much!
>
> Frank.
Received on Sat Oct 26 2002 - 12:40:03 CDT