Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Transaction per second
Ian Bacon <ibacon_at_ss4b.co.uk> wrote in message
news:944570519.20149.0.nnrp-10.c2de69c5_at_news.demon.co.uk...
> Is there any utility or view that could be used to work out transactions per
> second?
select sum(s.value)/((sysdate-max(i.startup_time))*86400)
from v$sysstat s, v$instance i
where s.name in ('user commits', 'user rollbacks')
Received on Wed Dec 08 1999 - 07:02:16 CST
![]() |
![]() |