RE: Statspack - Load Profile Section - "Transactions Per Second" Field ?........ Basic Qs
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.
Regards,
Brandon
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
I believe that is the number of currently open transactions.
On Feb 6, 2008 1:00 PM, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 06 2008 - 13:57:23 CST