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