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

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:

>
> Hi Folks
>
> From Statspack Report, what does "Transactions Per Second" field stand
> for?
>
> Is its Value directly proportional to the Number of Commits issued?
>
> How can the Value be INCREASED by changing the Application Transaction's
> Numbers / pattern Without Changing the Application Code?
> Will Application Transactions doing SELECTs only have NO impact on this
> Value?
>
> NOTE - This is needed for a Benchmark which is underway.
>
> Cheers & Thanks
>
> Vivek
>
>
>
> Load Profile Per Second Per Transaction
> ~~~~~~~~~~~~ --------------- ---------------
> Redo size: 5,182,240.85 4,559.71
> Logical reads: 113,130.04 99.54
> Block changes: 23,949.24 21.07
> Physical reads: 30.79 0.03
> Physical writes: 876.68 0.77
> User calls: 25,832.19 22.73
> Parses: 1,579.15 1.39
> Hard parses: 0.01 0.00
> Sorts: 537.52 0.47
> Logons: 9.31 0.01
> Executes: 22,923.99 20.17
> Transactions: 1,136.53
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l