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

--

**********************************************************
Uli  Harder
www: http://www.metron.co.uk/
Metron Technology Ltd.
Osborne House, Trull Road, Taunton, TA1 4PX
**********************************************************