How to get number of daily Transactions
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How to get number of daily Transactions

  1. #1
    Join Date
    Nov 2000
    Posts
    57

    How to get number of daily Transactions

    My managment asking me to get # of daily Transactions for particular Oracle Instance.

    It this possible to get?

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what do you class as a transaction? commits? rollbacks? or sql statements run

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by Eberman
    My managment asking me to get # of daily Transactions for particular Oracle Instance.

    It this possible to get?

    Thanks!
    Statspack, OEM.........
    "What is past is PROLOGUE"

  4. #4
    Join Date
    Nov 2000
    Posts
    57
    I would say commits and sql's

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well commits and rollbacks you can get from statspack

    sql statements executed isnt recorded

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by Eberman
    My managment asking me to get # of daily Transactions for particular Oracle Instance.

    It this possible to get?

    Thanks!
    To answer the question from Oracle point of view may be little bit difficult.

    Did you ask your Management to define "transaction"?

    Do not accept what ever management says and wants.

    If it's a sales order system, then it is easy to count the number of orders received in a day, but imagine, if it's a HR system, then what do you count?

    Tamil

  7. #7
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Quote Originally Posted by davey23uk
    well commits and rollbacks you can get from statspack

    sql statements executed isnt recorded

    Statspack should do it Dave, no?

    If management mean some kind of business transaction (an order etc) then thats simple to count. And if they mean 'oracle transaction' then statspack gives that quite clearly. And even SQL statements ... what about the 'Executes' stat (above 'Transactions' in the spreport output, under 'Load Profile'); isn't that a count of 'statments executed'? (in 9i)

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if all your application does it select freom tables then i dont believe statspack catches that

  9. #9
    Join Date
    Jun 2006
    Posts
    259
    You could try using auditing.
    Last edited by ixion; 09-19-2006 at 04:01 PM.

  10. #10
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by Eberman
    My managment asking me to get # of daily Transactions for particular Oracle Instance.
    Ask your management to what exactly to monitor:

    > commits/transaction
    > rollbacks/transaction
    > usercalls/transaction
    > logon/transaction
    > recursive calls/transaction

    collect them in the historical database and query the output. Over the run at peak db load can get the transactions currently executing against the db per second.
    "What is past is PROLOGUE"

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