Re: How to find out daily Transaction rate.

From: RWP <randy_prater_at_yahoo.com>
Date: Tue, 19 Jan 1999 19:37:08 -0800
Message-ID: <jgcp2.2817$IJ3.24218323@WReNphoon2>

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.

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.

rwp

   -**** Posted from remarQ, Discussions Start Here(tm) ****- http://www.remarq.com/ - Host to the the World's Discussions & Usenet Received on Tue Jan 19 1999 - 21:37:08 CST