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: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
