Transaction per process statistics.

[Andrei Petrov]

Hi Gurus

I have an HPUX host with an Oracle database running on it. There are differnt client processes which I can logically divide in some application groups. I can get the number of transaction per process or per group in Oracle terms. But it is not the statistics my client likes to see. He'd like to get tpm's per process or process group statistics.

Is it possible to get such a statistics?

[Jannik]

I know HP has a list with tpm statistix it is not official so i don't have it. But you could call HP and get the information from you local tecnical accond manager.
At least they are willing to give it if you say you are going to bye something :-)

[Andrei Petrov]

The numer of tpm's is characteristics of host. Let say my machine has 10000 tpm. I'd like to know how much of this tpms uses specified group of processes.

[Bill Hassell]

Not possible to measure because you have to define what is a transaction? I might define a transaction as reading or writing a record, but that is far too simplistic. In a database like Oracle, a transaction might be defined as a table lookup, a record retrieval, a modification to the record and a replacement of the record.

TPM is actually defined by a standards organization and they define exactly what is a trasnaction. The details are in http://tpc.org/