StatsPack and AWR Reports — Bits and Pieces — 2

This is the second post in a series on reading StatsPack and AWR reports.(The first is available here) Comparing Reports : Here are two 9.2 StatsPack extracts from one database: Extract A : 9.2 StatsPack Load Profile~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 56,031.63 3,084.68 Logical reads: 68,286.24 3,759.32 Block changes: 314.88 17.33 Physical reads: 842.92 46.40 Physical writes: 134.76 7.42 User calls: 271.32 14.94 Parses: 146.46 8.06 Hard parses: 7.37 0.41 Sorts: 93.83 5.17 Logons: 0.33 0.02 Executes: 296.70 16.33 Transactions: 18.16 Extract B : 9.2 StatsPack Load Profile~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 89,615.76 2,960.48 Logical reads: 210,302.81 6,947.42 Block changes: 541.83 17.90 Physical reads: 1,465.04 48.40 Physical writes: 161.68 5.34 User calls: 213.82 7.06 Parses: 125.28 4.14 Hard parses: 6.13 0.20 Sorts: 104.31 3.45 Logons: 0.35 0.01 Executes: 664.81 21.96 Transactions: 30.27 Extract B shows a higher volume of activity — Transactions