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