Redo Log

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.