[管理脚本] 数据库启动以来回滚率

select
    a.value commits,
    b.value rollbacks,
    to_char(b.value * 100/ (a.value + b.value), '90.99') || '%' rollbacks_rate
from
(
    select name, value
    from v$sysstat where name = 'user commits'
) a
,
(
    select name, value from v$sysstat
    where name = 'transaction rollbacks'
) b
/