Hi Cameron,
Oracle can use CPU affinity on NT. <Note:108512.1>
explains steps.
regards...
- Martin Kendall <Martin.Kendall_at_Rubus.com> wrote:
> 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
> 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:
> 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
> 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).
Danisment Gazi Unal
Web:
http://www.geocities.com/danisment
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal
INET: danisment_at_yahoo.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).
Received on Thu Apr 05 2001 - 08:26:22 CDT
