Re: Statspack - Load Profile Section - "Transactions Per Second" Field ?........ Basic Qs
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Wed, 6 Feb 2008 14:38:10 -0500
Hi,
Code snippets from spreport.sql and STAT_CHANGE procedure are more or less
self-explanatory:
sprepins.sql:
Transactions:' dscr, round(:tran/:ela,2) val
STAT_CHANGE:
tran := ucom + urol;
HTH
--romas
On 2/6/08, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> 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***
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
