RE: latch free: which latch

Ryan, I haven't reviewed this script recently to see if it is in fact still
valid, but it does run and I believe it is probably valid:


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')
/

-- Mark D Powell --


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of ryan.gaffuri@xxxxxxx
Sent: Tuesday, April 06, 2004 9:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: latch free: which latch


how do you determine transactions/second? 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: