-
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!
-
what do you class as a transaction? commits? rollbacks? or sql statements run
-
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"
-
I would say commits and sql's
-
well commits and rollbacks you can get from statspack
sql statements executed isnt recorded
-
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
-
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)
-
if all your application does it select freom tables then i dont believe statspack catches that
-
You could try using auditing.
Last edited by ixion; 09-19-2006 at 03:01 PM.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|