Re: number of transaction per row.

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 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."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Received on Mon Dec 26 2005 - 16:14:01 CST