Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: number of transactions in a day

Re: number of transactions in a day

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 1 Jun 2007 15:05:00 -0400
Message-ID: <49d668000706011205m2f167628rc0c7df6d6620befe@mail.gmail.com>


You can use something like statspack does:

user commits + user rollbacks

v$sysstat

On 6/1/07, dd yakkali <dd.yakkali_at_gmail.com> wrote:
> Is there any way of knowing howmany transactions happened in a day?
>
> Some damagement report needs this.
>
> Any help is appreciated.
>
> Thanks
> Deen

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 01 2007 - 14:05:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US