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

Makes sense. Thanks all

Kyle

On Mon, Apr 29, 2019 at 11:24 AM Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

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