Re: Basic question regarding parallelism and cpu usage

  • From: "Mark Brinsmead" <pythianbrinsmead@xxxxxxxxx>
  • To: Harvinder.Singh@xxxxxxxxxxxxx
  • Date: Fri, 2 Feb 2007 22:21:59 -0700

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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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

Other related posts: