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 > > >