Re: How to calulate the number of transactions commited during a specific time?

You might also try looking at the 'user commits' statistic in v$sysstat. Make note of the value at 10:00am, and then make a note of the value at 2:00pm, then subtract..

On 20 Oct 2000 04:20:19 GMT, Jerry <jerry_at_255.255.255.255> wrote:

>wjeffery_at_my-deja.com wrote:
>> Hi,
 

>> Is there any way to know the number of transactions commited
>> during a time period (eg 10:00am and 2:00pm)?
 

>> Thanks
>
>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
> Look at V$SQLAREA in addition to containing the text of all queries run
> since the database was last rebooted (providing it has enough space) it
> also contains the number of times each was executed. Select the total
> number of executions at the beginning of the time period and write down
> result. Repeat the selection at the end of the period and you will be
> able to compute the number of transactions.
Received on Fri Oct 20 2000 - 16:51:23 CDT