topic Re: Transaction per process statistics. in Operating System - HP-UX

Transaction per process statistics.

Andrei Petrov — Mon, 26 Sep 2005 09:16:01 GMT

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?

Re: Transaction per process statistics.

Jannik — Mon, 26 Sep 2005 09:25:01 GMT

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 :-)

Re: Transaction per process statistics.

Andrei Petrov — Mon, 26 Sep 2005 09:37:03 GMT

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.

Re: Transaction per process statistics.

Bill Hassell — Mon, 26 Sep 2005 12:17:43 GMT

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/