Re: measuring transaction throughput

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 29 Jun 2002 17:20:22 +0200
Message-ID: <uhrk991v0k2gb6@corp.supernews.com>

"James Williams" <willjamu_at_mindspring.com> wrote in message news:3d1dc623.58960332_at_nntp.mindspring.com...
> I have to do an application stress test using 8.1.7 on Solaris.
>
> I need to measure the Oracle transcations during the testing interval.
>
> Only things I can think of is maybe Log Miner after the fact or maybe
> some type of interrogation on v$transaction. We have a way to measure
> application transactions end to end but would like to measure database
> transactions also.
>
> Anyone out there got better ideas?

As the number of transactions was measured using utlbstat and utlestat, and statspack is the successor of utlbestat/estat you might want to setup statspack. IIRC, the files setting it up are spcreate.sql and spauto.sql to run a monitor job every hour, both in $ORACLE_HOME/rdbms/admin

Hth Received on Sat Jun 29 2002 - 10:20:22 CDT