Re: number of transactions in a day

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 1 Jun 2007 16:32:12 -0400
Message-ID: <49d668000706011332v313d961v9d777a3281a44f09@mail.gmail.com>

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

Received on Fri Jun 01 2007 - 15:32:12 CDT