What is Transaction Count and How to calculate it
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: What is Transaction Count and How to calculate it

  1. #1
    Join Date
    Feb 2001
    Posts
    176
    Transaction Count represents the total number of commits
    and rollbacks performed during a sample period. This statistic is an indication of how much work is being accomplished within the database. A spike in the transaction rate may not necessarily be bad. If response times stay close to normal, it means your system can handle the added load. Actually, a drop in transaction rates and an increase in response time
    may be indicators of problems. Depending upon the
    application, transaction loads may vary widely across
    different times of the day.


    TCount = deltaCommits + deltaRollbacks

    deltaCommits: difference of \'select value from v$sysstat where name=\'user commits\'\' between sample end and start

    DeltaRollbacks: difference of \'select value from v$sysstat where name=\'user rollbacks\'\' between sample end and start




    [Edited by uday on 04-03-2001 at 02:37 PM]

  2. #2
    Join Date
    Jul 2001
    Location
    ATlanta
    Posts
    1

    Question Transaction count

    If we just count Transaction rate by commits and rollbacks , what ever happens to all the read transactions ???
    what about the impact these will have on response time etc..???

  3. #3
    Join Date
    Aug 2001
    Posts
    64

    Talking can you exp.

    Hi,
    Can you explain what do you mean "between sample end and start"? Do you mean just pick an arbitrary time to start the query and end the query?

    Thanks.

  4. #4
    Join Date
    Nov 2000
    Posts
    56

    Wink Transaction counts

    Actually, the end and start time is not actually arbitrary.
    This is a part of tuning lesson and usually measured using the utlbstat and utlestat.sql.

    Rama

  5. #5
    Join Date
    May 2001
    Posts
    25

    I have tried the following query , It is giving the count of the cmmitted or rollback command.

    Please confirm, whether output of the query of the committed or rollback transaction or no of times we have run the commit or rollback command.

    thanks

    naresh

  6. #6
    Join Date
    Nov 2010
    Posts
    1
    Don't see the query you mentioned in your msg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width