Re: number of transactions per minute/hour

  • From: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Thu, 14 Sep 2006 19:02:12 +0200

Define USER transaction.

On 9/14/06, amonte <ax.mount@xxxxxxxxx> 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

Other related posts: