FreeLists / oracle-l / Re: number of transactions in a day

["DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> 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