From oracle-l-bounce@freelists.org Tue Apr 6 08:20:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i36DKhO30211 for ; Tue, 6 Apr 2004 08:20:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i36DKgo30206 for ; Tue, 6 Apr 2004 08:20:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F6BF634BBA; Tue, 6 Apr 2004 08:16:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02386-27; Tue, 6 Apr 2004 08:16:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 77F20634B41; Tue, 6 Apr 2004 08:16:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Apr 2004 08:14:52 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 499EA634B97 for ; Tue, 6 Apr 2004 08:14:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01849-54 for ; Tue, 6 Apr 2004 08:14:51 -0500 (EST) Received: from ahmler5.mail.eds.com (ahmler5.mail.eds.com [192.85.154.70]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9395C634B9B for ; Tue, 6 Apr 2004 08:14:49 -0500 (EST) Received: from ahmlir4.mail.eds.com (ahmlir4-2.mail.eds.com [192.85.154.134]) by ahmler5.mail.eds.com (8.12.10/8.12.9) with ESMTP id i36DO1Td001296 for ; Tue, 6 Apr 2004 09:24:01 -0400 Received: from ahmlir4.mail.eds.com (localhost [127.0.0.1]) by ahmlir4.mail.eds.com (8.12.10/8.12.10) with ESMTP id i36DNNcC021942 for ; Tue, 6 Apr 2004 09:23:24 -0400 Received: from USAHM102.amer.corp.eds.com (usahm102.exmi01.exch.eds.com [207.37.138.190]) by ahmlir4.mail.eds.com (8.12.10/8.12.10) with ESMTP id i36DNNOf021937 for ; Tue, 6 Apr 2004 09:23:23 -0400 Received: by USAHM102.amer.corp.eds.com with Internet Mail Service (5.5.2657.72) id ; Tue, 6 Apr 2004 09:23:23 -0400 Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA9C@USAHM018.amer.corp.eds.com> From: "Powell, Mark D" To: "'oracle-l@freelists.org'" Subject: RE: latch free: which latch Date: Tue, 6 Apr 2004 09:23:22 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 2585 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of ryan.gaffuri@cox.net Sent: Tuesday, April 06, 2004 9:16 AM To: oracle-l@freelists.org 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@freelists.org 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@freelists.org 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 -----------------------------------------------------------------