怎么样计算REDO BLOCK的大小

计算方法为(redo size + redo wastage) / redo blocks written + 16
具体见如下例子
计算方法为(redo size + redo wastage) / redo blocks written + 16
具体见如下例子
SQL> select name ,value from v$sysstat where name like '%redo%';
NAME VALUE
---------------------------------------------------------------- ----------
redo synch writes 2
redo synch time 0
redo entries 76
redo size 19412
redo buffer allocation retries 0
redo wastage 5884
redo writer latching time 0
redo writes 22
redo blocks written 51
redo write time 0
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
SQL> select (19412+5884)/51 + 16 '"Redo block(byte)" from dual;
Redo black(byte)
------------------
512

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/308563/viewspace-171873/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/308563/viewspace-171873/