My managment asking me to get # of daily Transactions for particular Oracle Instance.
It this possible to get?
Thanks!
Printable View
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
Statspack, OEM.........Quote:
Originally Posted by Eberman
I would say commits and sql's
well commits and rollbacks you can get from statspack
sql statements executed isnt recorded
To answer the question from Oracle point of view may be little bit difficult.Quote:
Originally Posted by Eberman
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
Quote:
Originally Posted by davey23uk
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.
Ask your management to what exactly to monitor:Quote:
Originally Posted by Eberman
> 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.
well, for me its a good practice that you put 2 date columns for each
table, date created and date updated. It helped me a lot to count
desired transactions. Usually my management just wanted
all created and updated transactions for the day. :)