Re: Transaction rates

Thanks I'll use this, but I believe these are the same sources of info the report.txt is created from. I am curious of how to get a more precise transaction rate. This information includes commits other than those performed by the user. I believe it also includes commits/transactions from changes made to the dictionary.

Thank you, Dave Turner

On Wed, Sep 27, 2000 at 02:30:29AM -0800, Hatzistavrou Giannis wrote:
> Dear David,
>
> I have found the following sql from an old mail posted to the list.
>
> select sum(s.value/(86400*(sysdate-to_date(i.value,'J')))) "tps"
> from v$sysstat s,v$instance i
> where s.name in ('user commits','transaction rollbacks')
> and i.key='STARTUP TIME - JULIAN';
>
> PS: Shows transactions/sec
>
> Regards
>
> Hatzistavrou Yannis
> DBA/Telco Analyst
>
> > -----Original Message-----
> > From: David Turner [SMTP:turner_at_tellme.com]
> > Sent: Τετάρτη, 27 Σεπτεμβρίου 2000 6:01 πμ
> > To: Multiple recipients of list ORACLE-L
> > Subject: Transaction rates
> >
> > What is the best way to measure transaction rates? I thought looking
> > at
> > the number of commits in report.txt would work but it seems too high.
> >
> > Thanks, Dave Turner
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David Turner
> > INET: turner_at_tellme.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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hatzistavrou Giannis
> INET: j.hatzistavrou_at_telesoft.gr
>
> 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_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).
Received on Wed Sep 27 2000 - 16:45:26 CDT