RE: number of transactions per minute/hour

Hi

> 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

The reason is quite simple. DML statements or queries are *not* transactions! For that reason Anjo asked the OP to give *his* definition of "USER transaction"... For a regular definition have a look here: http://en.wikipedia.org/wiki/Database_transaction.

Regards,
Chris

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