“Transactions” from “user commit” for sure.
On Mon, 29 Apr 2019 at 11:25 PM, kyle Hailey <kylelf@xxxxxxxxx> wrote:
Anyone have handy access to statspack files or know fo the top of their
heads where "Transactions" and "Executes (SQL)" come from in the Load
Profile? these should correspond to a stat in v$sysstat.
Thanks
Kyle
Load Profile Per Second Per Transaction Per Exec Per
Call
~~~~~~~~~~~~~~~ --------------- --------------- ---------
---------
DB Time(s): 1.7 0.0 0.00
0.00
DB CPU(s): 0.6 0.0 0.00
0.00
Redo size (bytes): 4,762,632.4 4,196.8
Logical read (blocks): 57,271.0 50.5
Block changes: 36,004.1 31.7
Physical read (blocks): 0.2 0.0
Physical write (blocks): 239.9 0.2
Read IO requests: 0.2 0.0
Write IO requests: 70.5 0.1
Read IO (MB): 0.0 0.0
Write IO (MB): 1.9 0.0
User calls: 3,746.0 3.3
Parses (SQL): 1,872.4 1.7
Hard parses (SQL): 0.0 0.0
SQL Work Area (MB): 1.3 0.0
Logons: 0.0 0.0
* Executes (SQL): 1,895.9 1.7*
Rollbacks: 0.0 0.0*
Transactions: 1,134.8
*
