+ Reply to Thread
Results 1 to 3 of 3

Count the transactions happened in a database

  1. Count the transactions happened in a database

    Hi all,

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


  2. Re: Count the transactions happened in a database

    "kavin" wrote in message
    news:1187239750.965380.224630@e9g2000prf.googlegroups.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.



  3. Re: Count the transactions happened in a database

    On Aug 16, 11:40 am, "Mark A" wrote:
    > "kavin" wrote in message
    >
    > news:1187239750.965380.224630@e9g2000prf.googlegroups.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


+ Reply to Thread