Re: number of transactions in a day

  • From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
  • To: "DIANNA GIBBS" <DIANNA.GIBBS@xxxxxxxxxxxxx>
  • Date: Fri, 1 Jun 2007 16:32:12 -0400

You should not do that :)

SQL> select name
 2   from v$sysstat
 3   where name like 'user_commit%' or name like 'rollback%';

NAME
----------------------------------------------------------------
user commits
rollbacks only - consistent read gets
rollback changes - undo records applied

I don't think you want to sum the latest two ;)

On 6/1/07, DIANNA GIBBS <DIANNA.GIBBS@xxxxxxxxxxxxx> wrote:

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: