prompt Redo log space requests to the number of redo entries should not be greater than 1 in 5000 select (req.value*5000)/entries.value "Ratio" from v$sysstat req, v$sysstat entries where req.name = 'redo log space requests' and entries.name = 'redo entries' /