Count the transactions happened in a database

kavin

Hi all,

can any one help me to get the number of transactions happened in a
database per day..

Aug 16 '07 #1

Mark A

"kavin" <ka*************@gmail.comwrote in message
news:11**********************@e9g2000prf.googlegro ups.com...

Hi all,

can any one help me to get the number of transactions happened in a
database per day..

How do you define a transaction? Is that number of commits? You could do a
snapshot for database and get that information, as well as number of
inserts, deletes, etc. You would need to flush the monitors at the start of
the day, and do the snapshot at the end of the day.

Aug 16 '07 #2

kavin

On Aug 16, 11:40 am, "Mark A" <nob...@nowhere.comwrote:

"kavin" <kavinilammur...@gmail.comwrote in message

news:11**********************@e9g2000prf.googlegro ups.com...

Hi all,

can any one help me to get the number of transactions happened in a
database per day..

How do you define a transaction? Is that number of commits? You could do a
snapshot for database and get that information, as well as number of
inserts, deletes, etc. You would need to flush the monitors at the start of
the day, and do the snapshot at the end of the day.

thanks a lot

Aug 20 '07 #3