From Paul.Parker@bmwna.com Tue, 27 Nov 2001 07:48:05 -0800 From: Paul.Parker@bmwna.com Date: Tue, 27 Nov 2001 07:48:05 -0800 Subject: RE: Number of Transactions per 24hr period? - Urgent Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Number of Transactions per 24hr period? - Urgent Denham,   Craig Shallahamer explores this issue in a paper on www.orapub.com about Response Time Analysis.    In essence, one way of calculating the no. of transactions can be from 'user commits' + 'user rollbacks', but it appears that you also want to calculate the "response time" for these transactions.  A slightly "harder" problem, as Craig suggests.   Good luck Paul   PS.  Good to see another South African on the list :) -----Original Message-----From: Denham Eva [mailto:EvaD@TFMC.co.za]Sent: Tuesday, November 27, 2001 7:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Number of Transactions per 24hr period? - Urgent Thanks, I have followed this line of thought, however, What parameter do I use as a yard stick? Perhaps execute count, parse(hard), OR parse(total) - This is what I am not sure of:) Thanks Denham -----Original Message----- From: Stephane Faroult [mailto:sfaroult@oriole.com] Sent: Tuesday, November 27, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Number of Transactions per 24hr period? - Urgent > Denham Eva wrote: > > Hello List, > > Please help, I would like to determine the number of transactions > processed by Oracle during a 24 hr period. > Is this possible? > > TIA > Denham > > ---------------------------------------------------------------------- > This e-mail message has been scanned for Viruses and Content and > cleared by MailMarshal - For more information please visit > www.marshalsoftware.com > ---------------------------------------------------------------------- This is typically the kind of information you find in V$SYSSTAT. Look at V$INSTANCE to get the exact time when your instance was started, V$SYSSTAT holds (mostly) cumulated values. -- Regards, Stephane Faroult Oriole Corporation Voice:  +44  (0) 7050-696-269 Fax:    +44  (0) 7050-696-449 Performance Tools & Free Scripts -------------------------------------------------------------- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult   INET: sfaroult@oriole.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com