Re: number of transactions in a day

From: DIANNA GIBBS <DIANNA.GIBBS_at_childrens.com>
Date: Fri, 01 Jun 2007 15:21:00 -0500
Message-Id: <4660395C020000AF00011742@CNET3.CHILDRENS.COM>

I ran something like this for a while...

spool sys$aux:[dba]trans.rep
set heading off
set feedback off
set serveroutput on
begin
  for lcntr in 1..60
  loop

      for c1 in (select sysdate, sum(value) sum from v$sysstat where name like 'user_commit%' or name like 'rollback%')
      loop
        dbms_output.put_line(c1.sysdate||','|| c1.sum);
        dbms_lock.sleep(60);
      end loop;

   end loop;
end;
/

>>> "Alexander Fatkulin" <afatkulin_at_gmail.com> 06/01/07 2:05 PM >>>
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 

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 01 2007 - 15:21:00 CDT