Re: Transactions per second count (URGENT)

Try this sql script. It accepts 1 command line argument - the number of seconds to count transactions (commits) over.

define seconds = &1
col v1 new_value _v1
set termout off
select value v1 from v$sysstat where name = 'user commits'
/

set termout on
exec dbms_lock.sleep(&seconds)
select (value - &_v1) / &seconds transactions_per_second from v$sysstat where name = 'user commits'
/

--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA


                                                                                                                   
                    Mahip Narayan                                                                                  
                    <Mahip_at_mahind        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    rabt.com>            cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    Ext: NA              Subject:     Transactions per second count (URGENT)                       
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/15/00                                                                                       
                    07:15 AM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   




Hi Lists,
I need an script to monitor transactions my system is executing
during a certion time interval. That is I need TPS (Transactions Per
Second).
Could you pl. send that script as body of the message,
Thanks and Regards,
Mahip
--
Author: Mahip Narayan
  INET: Mahip_at_mahindrabt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).