redo

Question

请问以下SQL什么意思，可以查出谁在频繁提交数据吗?
SQL> select sid,VALUE
  2  from v$sesstat s
  3  where s.statistic# = (select statistic# from v$statname where NAME='user commits')
  4  order by VALUE;       SID      VALUE
---------- ----------
         1          0
         2          0
         3          0
         4          0
         5          0
        15          0
        21          0
         6          0
        65          0
         9          0
        25          3       SID      VALUE
---------- ----------
        18        398
        50        978
        54       3143
        10      5840415 rows selected.SQL> select b.NAME, a.VALUE, round(SYSDATE- c.startup_time) day_old
  2  from v$sysstat a, v$statname b, v$instance c
  3  where a.statistic# = b.statistic#
  4  and b.NAME IN('redo wastage','redo size');NAME                                                                  VALUE
---------------------------------------------------------------- ----------
   DAY_OLD
----------
redo size                                                        1.1988E+12
        20redo wastage                                                     3501955072
        20

Answer 1

第一个查询出每个会话的提交次数
第二个查询产生的重做日志大小