Re: transactions per time period

In article <8pls4q$cng$1_at_solaris.cc.vt.edu>,   stellr_at_stell.cns.vt.edu (Ray Stell) wrote:
> Is there a view/table that will give the number of transactions
> per period of time?
>

Presuming that you are currently running 8i (8.1.5, 8.1.6) there is a view named V$TRANSACTION where this information would be available:

select count(*)
from v$transaction
where start_time between '...' and '...';

Check your installation for the data format of the START_TIME column; it is declared as a VARCHAR2(16).

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.