How to get number of daily Transactions

[Eberman]

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

It this possible to get?

Thanks!

[davey23uk]

what do you class as a transaction? commits? rollbacks? or sql statements run

[dbasan]

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

It this possible to get?

Thanks!

Statspack, OEM.........

[Eberman]

I would say commits and sql's

[davey23uk]

well commits and rollbacks you can get from statspack

sql statements executed isnt recorded

[tamilselvan]

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

[JMac]

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)

[davey23uk]

if all your application does it select freom tables then i dont believe statspack catches that

[ixion]

You could try using auditing.

[dbasan]

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.