RE: Transaction rates

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Wed, 27 Sep 2000 16:51:51 -0400
Message-Id: <10632.118073@fatcity.com>

I just tried out the query for fun, and on 8.1.6.2 it didn't work, = because
there is no KEY column in v$instance. The query below worked, though.

select sum(s.value/(86400*(sysdate-i.startup_time))) "tps"  from v$sysstat s,v$instance i
 where s.name in ('user commits','transaction rollbacks')

Diana

-----Original Message-----
From: Hatzistavrou Giannis [mailto:j.hatzistavrou_at_telesoft.gr] Sent: Wednesday, September 27, 2000 6:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Transaction rates

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=3D'STARTUP TIME - JULIAN';

PS: Shows transactions/sec

Regards

Hatzistavrou Yannis
DBA/Telco Analyst

> -----Original Message-----
> From: David Turner [SMTP:turner_at_tellme.com]
> Sent: =D4=E5=F4=DC=F1=F4=E7, 27 =D3=E5=F0=F4=E5=EC=E2=F1=DF=EF=F5 =
2000 6:01 =F0=EC
> To: Multiple recipients of list ORACLE-L
> Subject: Transaction rates

>=20

> 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.

>=20

> Thanks, Dave Turner
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: David Turner
> INET: turner_at_tellme.com

>=20


> 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).
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
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 Received on Wed Sep 27 2000 - 15:51:51 CDT