Re: How to find out daily Transaction rate.

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 20 Jan 1999 20:54:49 GMT
Message-ID: <36a62030.2286920@news.siol.net>

On Tue, 19 Jan 1999 19:37:08 -0800, randy_prater_at_yahoo.com (RWP) wrote:

>
>V$SYSSTAT has a statistic that I use for a guage of transaction count:
>
> "execute count"
> The total number of calls (user and recursive) that execute SQL
>statements.

AFAIK you can have 100.000 or whatever "executions" per day without having a single transaction being performed.

SELECT != TRANSACTION
1 TRANSACTION = 1..N INSERT/UPDATE/DELETE (N between 1 and infinite) 1 TRANSACTION = 1 COMMIT
>You can setup a process that subtracts the current count from the last count
>on an hourly or daily basis ( or whatever ) and save it to a table for
>reporting.
>Theres no built in daily transaction rate, you have to set up the process.

'user commits'

>rwp

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jan 20 1999 - 14:54:49 CST