RE: number of transactions in a day

  • From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
  • To: <dd.yakkali@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Jun 2007 20:48:28 +0100

It depends upon how you (or management) define a 'transaction'.  But you
could use statspack.  
You would have to accept that every time the database commits or rollback is
counted as a transaction.  
 
This has some obvious problems.  Batch programs often commit at points which
leave data in an functionally inconsistent state. 
Systems often contain processes that poll for work, and the these processes
frequently update their status on the database and commit that update.
 
The number of transactions is calculated as the sum of the change in the
number of 'user commits' and the number of 'user rollbacks'  as collected
from v$sysstat by the statspack snapshots.
 
regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz@xxxxxxxxxxxxxxx
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
<http://www.psftdba.com/> 
The PeopleSoft DBA Blog: http://psftdba.blogspot.com
<http://psftdba.blogspot.com/> 
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba 


  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of dd yakkali
Sent: Friday, June 01, 2007 7:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: number of transactions in a day


Is there any way of knowing howmany transactions happened in a day?
 
Some damagement report needs this.
 
Any help is appreciated.
 
Thanks
Deen

Other related posts: