RE: Making use of 2 CPUs

From: Martin Kendall <Martin.Kendall_at_Rubus.com>
Date: Thu, 05 Apr 2001 06:27:52 -0700
Message-ID: <F001.002E252E.20010405053027@fatcity.com>

Thanks Cameron, I will get the Unix Guy to look at it.

Martin

-----Original Message-----

Sent: 05 April 2001 14:16
To: Multiple recipients of list ORACLE-L

This is most likely an OS issue. Forking threads across processors is handled by the OS. I know of no Oracle configuration to specify processor affinity. When I called Oracle Support on this a while back, they confirmed that there was no way to specify this.

Does the processor sit idle at 0 percent utilization? If you are noticing that a non-parallelized SQL statement is utilizing a single processor, then this is normal. If you are noticing that the processor is completely idle then you probably need to address a hardware configuration issue.

If someone knows how to specify this, please send me the details and I will post them on my Oracle Resource site for you.

I hope this helps,

Cameron Michelis
www.OracleTuning.com

                    Martin Kendall

                    <Martin.Kendall@        To:     Multiple recipients of
list ORACLE-L      
                    Rubus.com>              <ORACLE-L_at_fatcity.com>

                    Sent by:                cc:

                    root_at_fatcity.com        Subject:     Making use of 2
CPUs                 
 

 

                    04/05/2001 06:35

                    AM

                    Please respond

                    to ORACLE-L

Hi folks,

I have noticed that even at 40% machine usage, Oracle is not using the second CPU on one of our servers.

Any idea what the best way to get it to do that.

I understood that DB_WRITER_PROCESSES > 2 was only worth it if you had more than 2 CPUs.

Martin Kendall Oracle DBA

t +44 (0) 1344 44 5104 | m +44 (0) 7973 816676 | f +44 (0) 13 44 44 5104
a 77 Shaftesbury Avenue | London W1D 5DU | UK

Rubus provides e-business solutions that turn innovative ideas into practical business reality.

:: rubus | www.rubus.com

Any views or opinions presented are solely those of the author and do not necessarily represent those of Rubus.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Martin Kendall
INET: Martin.Kendall_at_Rubus.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: cameron_michelis_at_nas.adp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Martin Kendall
INET: Martin.Kendall_at_Rubus.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message