Re: transactions per time period

Ray Stell wrote in message <8pls4q$cng$1_at_solaris.cc.vt.edu>...
>Is there a view/table that will give the number of transactions
>per period of time?

There's a PL/SQL script on my website which interrogates the v$systat view every 10 minutes (or whatever period you choose) and builds an accumulating table of the reported stats which you can then write simple SQL statements (examples included) to report against. It was written for Oracle 7.3.4 but should work for Oracle 8 (unless they've changed the statistic numbers).

URL: http://home.clara.net/dwotton/dba/monitor.htm

HTH, Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.