# Re: Queueing Theory in Oracle

Date: Thu, 13 Mar 2014 12:18:00 -0400

Message-ID: <CAAVg4uKaDzch7dc-SBnR8_i64-OJD3_FNA9Tg80aM3GVVkHjAA_at_mail.gmail.com>

I have a couple of papers from talks I gave at the Hotsos Symposiumn a few years ago.

Applying Queueing Theory Analysis to Oracle Statspack Data (2009) Determining Resource Utilization and Saturation Limits Using AWR history and Queueing Theory (2010)

I would be happy to post these somewhere if someone offers up a site.

I also just skimmed through this thread. I'll try to add on when I have a chance to read it in more depth.

Henry

On Wed, Mar 12, 2014 at 11:33 AM, Ls Cheng <exriscer_at_gmail.com> wrote:

*> Hi Jared*

*>*

*> So when the server arrives can we hear from you if the prediction is good*

*> enough :-?*

*>*

*> Just to check if Queueing Theory is ok*

*>*

*>*

*> Thanks*

*>*

*>*

*>*

*> On Wed, Mar 12, 2014 at 4:13 PM, Jared Still <jkstill_at_gmail.com> wrote:*

*>*

*>>*

*>> On Tue, Mar 11, 2014 at 1:34 PM, Karl Arao <karlarao_at_gmail.com> wrote:*

*>>*

*>>> From the paper, I did the simple math to estimate the end CPU*

*>>> requirement and utilization without doing the migration.*

*>>> Then I did the actual migration of workload and the numbers were about*

*>>> the same that I got from the math.*

*>>>*

*>>*

*>> Interesting discussion - I took Craig's Queuing course about 15 years*

*>> ago, and used it in the same manner for some new servers that had yet to*

*>> arrive*

*>>*

*>> It was quite a useful exercise.*

*>>*

*>> Jared Still*

*>> Certifiable Oracle DBA and Part Time Perl Evangelist*

*>> Sr Oracle DBA at Pythian*

*>> Pythian Blog http://www.pythian.com/blog/author/still/*

*>> Oracle Blog: http://jkstill.blogspot.com*

*>> Home Page: http://jaredstill.com*

*>>*

*>*

*>*

-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 13 2014 - 17:18:00 CET