RE: number of transactions in a day

From: David Kurtz <info_at_go-faster.co.uk>
Date: Fri, 1 Jun 2007 20:48:28 +0100
Message-ID: <055d01c7a485$d459a980$0a0a0a0a@GOFASTER4>

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_at_go-faster.co.uk
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dd yakkali
Sent: Friday, June 01, 2007 7:18 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 01 2007 - 14:48:28 CDT