| Finding number of transactions [message #400476] |
Tue, 28 April 2009 06:09  |
anjum.suri
Messages: 14
Registered: February 2008
|
Junior Member |
|
|
Hi All
Could anyone please tell me how can I find answers to below questions either by using AWR or SPREPORT or by any query?
1.) Is it possible to tell the average/estimated transaction count that takes place each day? e.g. during the working day 200 transactions take place on the database per day, say for 01/04/2009.
2.) Would it be possible to tell the number of transactions that take place per month (average/estimated). e.g March 2009
Thanks
|
|
|
|
|
|
| Re: Finding number of transactions [message #400494 is a reply to message #400476] |
Tue, 28 April 2009 08:20  |
anjum.suri
Messages: 14
Registered: February 2008
|
Junior Member |
|
|
Can we pull some meaningful information from below?
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 14,227.82 2,496.83
Logical reads: 59,739.67 10,483.69
Block changes: 89.61 15.73
Physical reads: 30,010.32 5,266.50
Physical writes: 4.43 0.78
User calls: 165.42 29.03
Parses: 36.73 6.45
Hard parses: 7.48 1.31
Sorts: 7.65 1.34
Logons: 0.12 0.02
Executes: 36.46 6.40
Transactions: 5.70
% Blocks changed per Read: 0.15 Recursive Call %: 47.98
Rollback per transaction %: 0.65 Rows per Sort: 1550.58
|
|
|
|
|
|
|
|
|
|
| Re: Finding number of transactions [message #401067 is a reply to message #400494] |
Fri, 01 May 2009 07:13 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Well, the bottom line: tells you that during the period of the report, you averaged 5.7 transactions per second.
Converting this to a monthly figure is left as an excercise for the reader (hint - make sure you get a series of samples to let you get a reliable figure for the Transactions/second)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
