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

 'executes (SQL)' comes from:

select snap_id, value from dba_hist_sysstat where stat_name = 'execute count' and snap_id ...

Divided by the elapsed time.

'Transactions' is a sum of 'user commits' and 'user rollbacks' as I see.

On Mon, 29 Apr 2019 at 19:06, Purav Chovatia <puravc_at_gmail.com> wrote:

> “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