RE: Statspack - Load Profile Section - "Transactions Per Second" Field ?........ Basic Qs

From: Allen, Brandon <>
Date: Wed, 6 Feb 2008 12:57:23 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450A5432DF@NT15.oneneck.corp>

I haven't looked at it for a while, but if you take a look at the statspack code (e.g. in spreport.sql, sprepins.sql, statspack procedures, etc.) it's pretty easy to track down exactly what statistics and calculations are used to get the numbers you see in the statspack report. IIRC, the transactions per second comes from the 'user commits' statistic in v$sysstat (and its snapshots in stats$sysstat). I think they might include either 'user rollbacks' or 'transaction rollbacks' in that figure too, but not sure off the top of my head so like I said - just go look at the code to find out for sure, especially considering it could be different depending on what version you're on.  


[] On Behalf Of Andrew Kerber

I believe that is the number of currently open transactions.

On Feb 6, 2008 1:00 PM, VIVEK_SHARMA <> wrote:

        From Statspack Report, what does "Transactions Per Second" field stand for?         

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Wed Feb 06 2008 - 13:57:23 CST

Original text of this message