RE: Binding a process to a CPU .

Why would one think on a database server that one could manage run queues better than Unix?

I *do* understand a (tiny) bit about onchip processor cache and register/pipeline flushes, but I think the value of having "all" processors available to the scheduling algorithm outweighs that.

I once knew a guy from Sequent who would probably be able to paper-napkin me source code in Dynix/ptx that would support this claim, but he is on vacation only working 60 hours a week now.

Anyway, I'd experiment with affinities, but track results carefully, and only then decide.....

sounds like fun work....good luck, buena suerte, mit gluck, bon chance, et cetera....

|| -----Original Message-----
|| From: Shreepad Vaidya [mailto:Shreepad.Vaidya_at_alltel.com]
|| Sent: Tuesday, May 22, 2001 8:16 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Binding a process to a CPU .
||
||
||
||
|| Hi,
|| I wish to test Parallel Query .
||
|| HP-UX 10.2 K Class machines , 4 CPU 2 GB RAM , Oracle 7.3.4.4
||
|| When the background processes are created , Can I bind ( a slave
|| process related to Parallel query server) them to a specific CPU . ?
|| Is this Possible .?
|| Has anyone checked this out .? Any Problems.
||
||
|| shreepad.
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Shreepad Vaidya
|| INET: Shreepad.Vaidya_at_alltel.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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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).