| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Transaction rates
I run this command (production) and my results are :
SQL> select sum(s.value/(86400*(sysdate-i.startup_time))) "tps"
2 from v$sysstat s,v$instance i
3 where s.name in ('user commits','transaction rollbacks');
tps
What is the interpretation ?
Can you help me ?
Regards,
Diana Duncan <Diana_at_fileFRENZY.com>@fatcity.com on 27/09/2000 04:56:21 = PM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: Transaction rates
I just tried out the query for fun, and on 8.1.6.2 it didn't work, beca=
use
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-----
Sent: Wednesday, September 27, 2000 6:30 AM
To: Multiple recipients of list ORACLE-L
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 2=
000 6:01 =F0=EC
> 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 List=
s
> --------------------------------------------------------------------
> 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diana Duncan INET: Diana_at_fileFRENZY.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 mayReceived on Fri Sep 29 2000 - 11:03:40 CDT
 |
 |