RE: measuring TPM

Charlie,

  I understand a transaction as a succession of SQL statements between two successive COMMITs or ROLLBACKs - you will find inside V$SYSSTAT how many COMMITs and ROLLBACKs were issued.   If you are interested, besides transactions proper, in the number of statements executed, then have a look at 'execute count'. You also have stats to tell you how many of them were recursive statements I believe.   Talking about metrics (and forgetting about what you have been asked to provide :-)), methinks you can have a reasonably fair (and balanced) view of what is going on by collecting six values :   o Number of sessions and number of executions to see what users are asking of your database   o Redo blocks written to see the 'update' activity and the number of bytes sent which roughly tell you what users want to be done   o Physical and logical I/Os to see how efficiently it is done

Discrepancies should trigger investigation.

HTH, Stephane Faroult

>----- ------- Original Message ------- -----
>From: Charlie_Mengler_at_HomeDepot.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Wed, 28 Jan 2004 07:29:25
>
>
>I've been asked to provide value for the
>Transactions Per Minute
>going through our primary OLTP production database.
>
>
>I believe I can use deltas in SCN values to measure
>"transactions"
>which do INSERT/UPDATE/DELETE and then COMMIT;
>
>Is there any way to measure/count the number of
>SELECTs which occur?
>If so, how?
>
>How would you derive a value for TPM for your DB?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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).