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> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
