Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to make Oracle use all CPUs on SUN

Re: How to make Oracle use all CPUs on SUN

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 26 Oct 2002 17:40:03 GMT
Message-ID: <SrAu9.120160$La5.373811@rwcrnsc52.ops.asp.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US