Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 27963 invoked from network); 2 Feb 2007 23:23:13 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 23:23:13 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 382825D596C; Sat, 3 Feb 2007 00:22:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17705-01-7; Sat, 3 Feb 2007 00:22:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BDA75D5A09; Sat, 3 Feb 2007 00:22:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 03 Feb 2007 00:20:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E19245D50C3 for ; Sat, 3 Feb 2007 00:20:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17196-01 for ; Sat, 3 Feb 2007 00:20:47 -0500 (EST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ADDE35D0FF3 for ; Sat, 3 Feb 2007 00:20:47 -0500 (EST) Received: by wx-out-0506.google.com with SMTP id i30so1635994wxd for ; Fri, 02 Feb 2007 21:21:59 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=hAWC3hNC9+eiPkjq4grHzMMJ9Uq1IISJ3NDzFG9uR4uuZVqI7wKC6a14GtitfwY1YdHgPef3NTv4fdKw6+YxZUxVWf5gIERryToq+2/gNa7komA2rra7KQWxRN9Bm6+3BDGZeVlVGzAR0urs0t7aNkVuhOhRrp8cq8OUhKxBrAQ= Received: by 10.70.131.20 with SMTP id e20mr7031452wxd.1170480119238; Fri, 02 Feb 2007 21:21:59 -0800 (PST) Received: by 10.70.17.6 with HTTP; Fri, 2 Feb 2007 21:21:59 -0800 (PST) Message-ID: Date: Fri, 2 Feb 2007 22:21:59 -0700 From: "Mark Brinsmead" To: Harvinder.Singh@metratech.com Subject: Re: Basic question regarding parallelism and cpu usage Cc: oracle-l In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14329_5533986.1170480119202" References: X-archive-position: 45106 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: pythianbrinsmead@gmail.com Precedence: normal Reply-to: pythianbrinsmead@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_14329_5533986.1170480119202 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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@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 ------=_Part_14329_5533986.1170480119202 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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@freelists.org <oracle-l-bounce@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 ------=_Part_14329_5533986.1170480119202-- -- http://www.freelists.org/webpage/oracle-l