RE: i know cary millsap is super smart but...

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 27 Aug 2013 21:55:22 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E86BC2_at_M1EXCHMB11.mmi.local>

I would like to check for understanding: This paper appears to apply very specifically to Oracle Applications Concurrent Manager. It states that one should not run more than 2x*number of CPU batch jobs on an Oracle Applications system (E-business Suite).

The ideas in this paper do not extend to ETL batch jobs and their parallel processes? For example, on a 32 core system, would I be limited to never using more than 64 parallel processes simultaneously?

Thanks for your time,

Josh C.

From: Cary Millsap [mailto:cary.millsap_at_method-r.com] Sent: Friday, June 14, 2013 6:04 PM
To: ahmusch_at_gmail.com
Cc: Josh Collier; oracle-l_at_freelists.org Subject: Re: i know cary millsap is super smart but...

Josh and Adam,

I was just discussing that this week with a client. I've asked the same question, and I just haven't done the tests yet.

My expectation would be that for a two-quad-core system, the number of "effective CPUs" (let's call it) would be something less than 2 x 4 = 8 but more than just 2. Probably 6-ish, I would expect. ...Meaning that on a 2x quad-core system, you could apply the idea behind the paper as if the actual number of CPUs were something like 6.

I'd love to learn what you find out if you test it.

Cary Millsap
Method R Corporation

On Fri, Jun 14, 2013 at 2:37 PM, Adam Musch <ahmusch_at_gmail.com<mailto:ahmusch_at_gmail.com>> wrote: I would think so, from a certain point of view. Each core is reported to the OS as a CPU, and that's what you should use at it pertains to the rule of 2. So if you have two cpus each with four course, your rule of 2 number would be 8.
The underlying mathematics of queuing theory still remain the same.

On Fri, Jun 14, 2013 at 2:08 PM, Josh Collier <Josh.Collier_at_banfield.net<mailto:Josh.Collier_at_banfield.net>>wrote:

> This paper is 13 years old, is it still valid in the era of quad core
> processors?
> Batch Queue Management and the Magic of '2'
> Cary Millsap/Hotsos Enterprises, Ltd.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Adam Musch
ahmusch_at_gmail.com<mailto:ahmusch_at_gmail.com>


--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 27 2013 - 23:55:22 CEST