RE: Statspack - Load Profile Section - "Transactions Per Second" Field ?........ Basic Qs
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <andrew.kerber@xxxxxxxxx>, <VIVEK_SHARMA@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Feb 2008 12:57:23 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxx> 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.
Other related posts:
