| 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
this will help you to calculate the tps
and answer to your question is you less than 1 tps or i can say you have 1
tps.
The number of seconds to count transactions (commits) over.define seconds = &1
col v1 new_value _v1set termout off
select value v1 from v$sysstat where name = 'user commits'
/
set termout on
exec dbms_lock.sleep(&seconds)
select (value - &_v1) / &seconds transactions_per_second from v$sysstat
where name = 'user commits'
/
>From: "Leonardo Fernandez" <lfernand_at_cmsenergy.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Transaction rates
>Date: Fri, 29 Sep 2000 08:05:46 -0800
>
>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
>---------
>.19121869
>
>What is the interpretation ?
>Can you help me ?
>Regards,
>
>---------------------- Forwarded by Leonardo Fernandez/CEG/CMS on
>29/09/2000 11:48 AM ---------------------------
>
>
>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:
>
>
>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-----
>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='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).
>--
>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 may
>also send the HELP command for other information (like subscribing).
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Leonardo Fernandez
> INET: lfernand_at_cmsenergy.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).
 |
 |