Re: AWR/Statspack where does Executes and Transactions come from

“Transactions” from “user commit” for sure.

On Mon, 29 Apr 2019 at 11:25 PM, kyle Hailey <kylelf_at_gmail.com> 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
> *
>
>
>

--
http://www.freelists.org/webpage/oracle-l