RE: number of transactions in a day

Certainly there is:  

1. Define your transactions.
2. Have each transaction toss a bean in a bucket when it commits.
3. Count the beans.

Rendered in damanagementese bean counterism for ease of translation.  

Be advised, step 1 is rarely completed, so I have no degree of confidence on how often step 2 is comprehensively completed within an average organization.  

Be advised, without completing steps 1 and 2, you might as well just quote 42 as the anwer for #3. Some folks use bytes of redo generated as a proxy for workload, but that is not usually what is meant by transaction.  

Regards,  

mwf  

PS: There are several rather long threads discussing just exactly various persons, companies, systems, and hardware vendors count as "transactions" in the archives of this list and several other lists, so my 42 cents is that we not rehash them yet again here.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dd yakkali
Sent: Friday, June 01, 2007 2: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