RE: measuring TPM

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 29 Jan 2004 08:09:27 -0800
Message-ID: <F001.005DE5DC.20040129080927@fatcity.com>

And these would be CPM (commits per minute) and RPM (rollbacks per minute).

If you really want a transaction, you have to code it yourself, otherwise all you can get is CPM and RPM.

If your transactions_per_minute ( or commits_per_minute) is low use this handy script to bump it up.

create table my_dual as select * from dual
/

begin
for i in 1 .. 1000
loop
  insert into my_dual values(i);
  commit;
  delete from my_dual;
  commit;
end loop;
end;
/

add salt and pepper to taste, serve with nice red wine, enjoy.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Mladen Gogala
Sent: Wednesday, January 28, 2004 11:09 AM To: Multiple recipients of list ORACLE-L

Well, as you are well aware of, you cannot measure without impacting. I know of the following methods:

Turn on auditing, count all transactions from dba_audit_trail table within a day and divide by the number of minutes in 9 hours. That will give you an average TPM number during the working hours. The problem is that auditing will impact the transaction rate.
Pick a single user, a chosen "average Joe" (or Josephine, to to avoid accusations for gender bias), create a logon trigger which will record "user commits" from v$sesstat and that will be the number of transactions. Divide by the number of minutes and multiply by the number of users on your system. The problem with this method is that it is usually very hard to pick up an average overall user of the system, so the whole thing is performed by department.
Count user commits in v$sysstat, which will count them system-wide. Divide by period. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 29 2004 - 10:09:27 CST