SQL> select name,value from v$sysstat where name like '%redo%';
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 40988
redo synch time 75470
redo blocks read for recovery 0
redo k-bytes read for recovery 0
redo k-bytes read for terminal recovery 0
redo entries 6246582
--日志信息大小
redo size 2355125180
redo entries for lost write detection 0
redo size for lost write detection 0
redo size for direct writes 70483820
redo buffer allocation retries 110
NAME VALUE
---------------------------------------------------------------- ----------
--日志空间浪费
redo wastage 26642760
redo writes 107565
redo blocks written 4807728
redo write time 159804
redo blocks checksummed by FG (exclusive) 1160961
redo blocks checksummed by LGWR 0
redo log space requests 786
redo log space wait time 7025
redo ordering marks 132714
redo subscn max counts 224140
redo write broadcast ack time 0
NAME VALUE
---------------------------------------------------------------- ----------
redo write broadcast ack count 0
redo k-bytes read total 2527839
redo k-bytes read (memory) 0
redo k-bytes read total by LNS 0
redo k-bytes read (memory) by LNS 0
27 rows selected.
