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)