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.