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