Home » RDBMS Server » Performance Tuning » statspack
statspack [message #64695] Sun, 28 December 2003 18:22 Go to next message
ashokmote
Messages: 56
Registered: December 2003
Member
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 3,765.90 15,432.60
Logical reads: 606.58 2,485.73
Block changes: 24.76 101.48
Physical reads: 14.53 59.56
Physical writes: 5.55 22.76
User calls: 34.22 140.24
Parses: 4.87 19.95
Hard parses: 0.09 0.35
Sorts: 21.98 90.08
Logons: 0.08 0.33
Executes: 38.66 158.43
Transactions: 0.24


wat the meaning of these stats .wat it is showing .can any explain everything in detail.if there is any tutorial on this topic please mention the link.
can any one explain this statistics. i could not understand this statistics.
Re: statspack [message #64700 is a reply to message #64695] Mon, 29 December 2003 08:26 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Most of those are self-explanatory. For more details,refer to


Statistics
Previous Topic: statistics
Next Topic: sql query and explain plan
Goto Forum:
  


Current Time: Sun Dec 22 22:33:02 CST 2024