--
-- log_buffer_tune.sql
--

PROMPT
PROMPT If many retries, raise LOG_BUFFER parameter
PROMPT

COLUMN name FORMAT a35

SELECT name,value FROM v$sysstat
WHERE name='redo buffer allocation retries';

PROMPT
PROMPT If many wait events, raise LOG_BUFFER parameter
PROMPT

COLUMN event FORMAT a20

SELECT event,total_waits,time_waited
FROM v$system_event WHERE event='log buffer space';