RE: Transaction rates

From: Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr>
Date: Wed, 27 Sep 2000 12:03:24 +0300
Message-Id: <10632.117965@fatcity.com>

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).
Received on Wed Sep 27 2000 - 04:03:24 CDT