I have three redolog files in our Oracle system of 100 MB each. Of which only one of the group is active. Now whenever i query the v$sysstat i get the value for 'redo buffer allocation retries' as 6 and 'redo log space requests' as 9. What could be the possible reason should i need to increase the log buffer parameter. Or its some other problem. The same problem i encountered last week where in the values where quite high. I had shutdown the system and restarted the database the problem was resolved. Should i need to modify the parameter log_checkpoint_interval.
Awaiting your comments on the same.