| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction monitoring
boo <boo_at_yahoo.com> wrote in message news:38874497.30649DB2_at_yahoo.com...
> Running Oracle 8.0.5 on Solaris 2.7
> I know I have seen this posted before, but is there a way to determine
> transactions per minute in an Oracle Database?
> This information is often requested by hardware vendors, and I haven't
> found a way to determine this.
>
> Thanks for any help.
>
>
Hi,
Assuming you want to know the number of sessions per minute you could make
use V$SYSSAT which tells the cum. login since database startup. If you want
to know how many transactions there are (in Oracle terms this a
session/command that requires a commit and "changes" the database content)
then the same table holds the number of cum. commits issued.
Something like ...
select v.name, v.value from v$sysstat v where v.name in ('logons cumulative','user commits');
will hopefully work. I don't if anyone has ever tested the reliability of these numbers.
Bye Uli
--
 |
 |