Re: Basic question regarding parallelism and cpu usage

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Fri, 2 Feb 2007 22:21:59 -0700
Message-ID: <cf3341710702022121r5ec1edf3nbe948a1462711277@mail.gmail.com>

Harvinder,

Silly question: You wouldn't happen to be using Oracle Express Edition (XE), would you?

If so, the database is restricted to never use more than one CPU at a time.

If not, maybe you just need to start up a few more sessions and give the database something to do... :-)

On 1/31/07, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
>
> Hi,
>
> We have a 8 cpu machine and I can see that oracle is not using more than
> 1 cpu at a time and there are always >2 processes in runnable state
> ...
>
>

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 02 2007 - 23:21:59 CST