| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Making use of 2 CPUs
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.
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 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Apr 05 2001 - 07:32:00 CDT
(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: 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).
 |
 |