From EvaD@TFMC.co.za Tue, 27 Nov 2001 04:44:33 -0800 From: Denham Eva Date: Tue, 27 Nov 2001 04:44:33 -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 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