Re: way to check how many transactions been process

On Nov 10, 11:24 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> On Nov 10, 10:33 am, aaa <aaa_mem..._at_newsguy.com> wrote:
>
> > We have ORACLE 9ir2 on LINUX servers. Does there has way or script which can
> > check how many transactions been process?
>
> > Thnaks.
>
> Hi,
>
> If by transactions you mean commits, then if you have statspack
> installed, you can query stats$sysstat for the difference in 'user
> commits' over a period of time.
>
> HTH,
>
> Steve

How about this:

set echo off

--
-- SQL*Plus script to calculate Transactions Per Second for version 8+
--
-- 20020513  Mark D Powell   New, cre as resp 2 metalink req fr ver 7
Query
--
--  Version 7 Query:
--  SELECT SUM(s.value/
--  (86400*(SYSDATE - TO_DATE(i.VALUE,'J')))) "tps"
--  FROM V$SYSSTAT s, V$INSTANCE i
--  WHERE s.NAME in ('user commits','transaction rollbacks')
--  AND i.KEY = 'STARTUP TIME - JULIAN'
--
select
  round(sum(s.value / (86400 * (SYSDATE - startup_time))),3) "TPS"
from
  v$sysstat  s
 ,v$instance i
where s.NAME in ('user commits','transaction rollbacks')
/

HTH -- Mark D Powell --