Re: Basic question regarding parallelism and cpu usage

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: