oracle - Oracle statspack 报告中是否有任何参数来指示完成了多少次提交？

Question

查看 Oracle Statspack 报告，该报告在批处理程序之前和之后都有准确的快照，是否可以说在数据库上完成了多少提交？已完成多少笔交易？

标签： oraclestatspack

Answer 1

在 Load Profile 部分，您有每秒事务数和每秒回滚数：

   Load Profile              Per Second    Per Transaction    Per Exec    Per Call
~~~~~~~~~~~~      ------------------  ----------------- ----------- -----------
      DB time(s):                0.4                0.0        0.01        0.06
       DB CPU(s):                0.2                0.0        0.00        0.03
       Redo size:           20,766.2            2,092.1
   Logical reads:              548.5               55.3
   Block changes:              138.3               13.9
  Physical reads:               22.9                2.3
 Physical writes:               16.5                1.7
      User calls:                7.0                0.7
          Parses:                9.2                0.9
     Hard parses:                0.0                0.0
W/A MB processed:                1.8                0.2
          Logons:                0.1                0.0
        Executes:               62.6                6.3
       Rollbacks:                0.0                0.0
    Transactions:                9.9