Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to determine the number of transactions per minute

Re: How to determine the number of transactions per minute

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Mon, 11 Dec 2000 23:46:25 -0800 (PST)
Message-Id: <10707.124289@fatcity.com>


Hi,

You can count how many commits thare are per minute,hour,...

select v$sysstat.value  
from   v$sysstat, v$statname 
where  v$statname.name='user commits' 
and    v$sysstat.statistic#=v$statname.statistic#;

Counting user rollbacks is also interesting sometimes.


Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Tue Dec 12 2000 - 01:46:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US