RE: Queueing Theory in Oracle
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2014 14:30:05 +0000
It's an interesting question - and I don't think you can find a current metric
that would help unless you started doing something a little clever with ASH.
In an OLTP system something like 'buffer gets per user call" would probably be
a reasonable fit - but there's no capture at that granularity. Similarly disc
I/O requests per call might be appropriate. Then there are things like disk
I/O requests per disc per second. But every possibility I think of requires
too fine a level of granularity unless you can find a way to construct a valid
model from the samples in v$active_session_history.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Ls Cheng [exriscer@xxxxxxxxx]
Sent: 11 March 2014 14:20
To: Paul Houghton
Cc: Oracle Mailinglist
Subject: Re: Queueing Theory in Oracle
Hi
I have had a quick read, I think the link you posted talks about queue time but
not about queueing theory such as a M/M/n model. The problem is I am not able
to find a database metric that is exponential distributed which allows us to
use the M/M/n queueing theory.
Thanks
On Tue, Mar 11, 2014 at 3:16 PM, Paul Houghton
<Paul.Houghton@xxxxxxxxxxxxxxx<mailto:Paul.Houghton@xxxxxxxxxxxxxxx>> wrote:
Craig Shallahamer talks about queuing theory in the following blog post.
http://shallahamer-orapub.blogspot.co.uk/2011/08/why-tuning-oracle-works-and-modeling-it.html
I hope this is helpful
PaulH
Other related posts:
