AWR/Statspack where does Executes and Transactions come from
From: kyle Hailey <kylelf_at_gmail.com>
Date: Mon, 29 Apr 2019 10:53:36 -0700
Message-ID: <CADsdiQhF5doDBw0fAbDp1ezY-rgEd1G68x_ccp=U+qEO_EJ6wg_at_mail.gmail.com>
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.
*
Date: Mon, 29 Apr 2019 10:53:36 -0700
Message-ID: <CADsdiQhF5doDBw0fAbDp1ezY-rgEd1G68x_ccp=U+qEO_EJ6wg_at_mail.gmail.com>
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-lReceived on Mon Apr 29 2019 - 19:53:36 CEST