Re: number of transactions in a day
- From: "DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>
- To: <afatkulin@xxxxxxxxx>,<dd.yakkali@xxxxxxxxx>
- Date: Fri, 01 Jun 2007 15:21:00 -0500
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
