Re: number of transaction per row.
- From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Mon, 26 Dec 2005 11:14:01 -0400
Hi,
I guess you can do it two ways. One is by measuring 'user commits'
statsicts.(Statistic# 4 in v$statname). Run program and measure user commits
before and after and then divide the total elapsed time by the number of
commits to arrive at the transactions per second
The other way is to measure the number of recods that your program process
using SQL(Actual business transactions) and divide the total wallclock
elapsed time by the number of business transactions processed.
I would prefer to do the later. Experts correct if I am wrong
Best Regards
Sriram Kumar
On 12/26/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote:
>
> God Day everyone,
>
> Is there any querey to find out the 'number of transaction per minute'
> in oracle database? In statspack report, we see 'number of transaction
> per minute', how can I get this value without executing the statspack,
> i.e., using sql.
>
>
> --
> Best Regards,
> Syed Jaffar Hussain
> OCP 8i & 9i DBA,
> Banque Saudi Fransi,
> Saudi Arabia
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
