doc

    Name:    redowait.sql

    Author:  Mark Gurry

    This script lists waits for the redo log buffer. The waits can
    usually be tuned by increasing the LOG_BUFFER parameter or by
    tuning your checkpoints. 

#

ttitle 'LOG_BUFFER and Redo Log Tuning Information  '  

SELECT NAME, VALUE 
  FROM V$SYSSTAT
 WHERE NAME in ('redo log space requests', 
                'redo buffer allocation retries');