RE: Number of Transactions per 24hr period? - Urgent

From: <Paul.Parker_at_bmwna.com>
Date: Tue, 27 Nov 2001 07:48:05 -0800
Message-ID: <F001.003CDB20.20011127073520@fatcity.com>

<FONT face=Arial color=#0000ff
size=2>Denham,
<FONT face=Arial color=#0000ff
size=2> 
Craig
Shallahamer explores this issue in a paper on <A href="http://www.orapub.com">www.orapub.com about Response Time Analysis. 
<FONT face=Arial color=#0000ff
size=2> 
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.
<FONT face=Arial color=#0000ff
size=2> 
Good
luck
<FONT face=Arial color=#0000ff
size=2>Paul
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>PS.  Good to see another South African on the list :)

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Denham Eva   [mailto:EvaD_at_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 [<A
  href="mailto:sfaroult_at_oriole.com">mailto:sfaroult_at_oriole.com]   Sent: Tuesday, November 27, 2001 1:50 PM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>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? <FONT
  size=2>> > 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. -- <FONT
  size=2>Regards,
  Stephane Faroult Oriole
  Corporation Voice:  +44  (0) 7050-696-269   Fax:    +44  (0) 7050-696-449
  Performance Tools & Free Scripts <FONT

  size=2>-------------------------------------------------------------- 

  <A target=_blank
  href="http://www.oriole.com">http://www.oriole.com, designed by Oracle   DBAs for Oracle DBAs <FONT

  size=2>-------------------------------------------------------------- 

• Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Stephane Faroult <FONT size=2>  INET: sfaroult_at_oriole.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- 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).

  This e-mail message has been scanned for Viruses and Content and cleared by   MailMarshal - For more information
  please visit <A
  href="http://www.marshalsoftware.com">www.marshalsoftware.com       Received on Tue Nov 27 2001 - 09:48:05 CST