Re: number of transactions per minute/hour

Well a benchmark worth its salt will of course define its own transactions. For example the tpc-c benchmark describes tpm as

TPC-C Benchmark Results

*Q*: What do TPC-C throughput numbers mean?

*A*: You must understand what the benchmark is intended to measure, before you can understand throughput. Throughput, in TPC terms, is a measure of maximum sustained system performance. In TPC-C, throughput is defined as how many New-Order transactions per minute a system generates while the system is executing four other transactions types (Payment, Order-Status, Delivery, Stock-Level). All five TPC-C transactions have a certain user response time requirement, with the New-Order transaction response time set at 5 seconds. Therefore, for a 710 tpmC number, a system is generating 710 New-Order transactions per minute while fulfilling the rest of the TPC-C transaction mix workload.

You could also take a wander over to
http://dominicgiles.com/swingbench.htmland take a look at how the swingbench oracle performance testing tool works - you can extend it yourself as well.

So benchmarks returning transactions per minute is simple, the definition and measure are all defined in the benchmark. The real issue of course is how you define your own transactions. To be honest I'd measure Oracle transactions/minute as a proxy for real transactions - with the proviso that application upgrades and changes make the comparisons unreliable except in very general terms. .

On 9/15/06, LS Cheng <exriscer_at_gmail.com> wrote:
> Not sure but I think it is very tedious to get those figures.... I always
> wondered how benchmark tools gives you informations such as transaction
per
> minute, I think those tools dont use v$sysstat for these purposes
>
>
>
>
> On 9/14/06, amonte <ax.mount_at_gmail.com> wrote:
> >
> >
> > Hi
> >
> > DELETE/UPDATE/INSERT/SELECT, non-recursive SQL.
> >
> > In this database it only houses an application under a schema.
> >
> > Thanks
> >
> > Alex
> >
> >
> >
> > On 9/14/06, Anjo Kolk <anjo.kolk_at_oraperf.com > wrote:
> > >
> > > Define USER transaction.
> > >
> > >
> > >
> > > On 9/14/06, amonte <ax.mount_at_gmail.com> wrote:
> > > >
> > > > Hi
> > > >
> > > > Does anyone know how to obtain the number of USER transactions per
> hour? Or per minute?
> > > >
> > > > I know from user commits and user tollbacks we can get roughly the
> number of Updates/Inserts/Deletes. However I am also interested in SELECT.

> > > >
> > > > I have looked at:
> > > >
> > > > Parse calls, not good since it wont give correct numbers if my
> application behaves well and dont use event soft parses.
> > > > Execute count, not good because I am not sure why, sometimes for
each
> query it increases by 1 but sometimes by 3, 4, or 5 or even more. This has
a
> problem because it includes recursive calls as well.
> > > >
> > > > TIA
> > > >
> > > > Alex
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > --
> > > Anjo Kolk
> > > Owner and Founder OraPerf Projects
> > > tel: +31-577-712000
> > > mob: +31-6-55340888
> >
> >
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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