|
[oracle-l]
||
[Date Prev]
[06-2007 Date Index]
[Date Next]
||
[Thread Prev]
[06-2007 Thread Index]
[Thread Next]
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
--
http://www.freelists.org/webpage/oracle-l
|
