redo log buff size and sga_target control
592815Jan 8 2009 — edited Jan 10 2009Hi Experts,
based on SQL from meatlink
clear breaks
clear computes
clear columns
title 'REDO CONTENTION REPORT" skip
COULM value format 999,999,999
select substr(name, 1,30) name, value from v$sysstat
where name ='redo log space requests';
if value > 0 then increase 5% fro log_buffer in init.ora
I got value over 100 to 167. But based on SGA_target, we already set a base line 6976512bit in 1.9G SGA.
sga_target should control log_buff automatically. So do i need to increase log_buffer size?
also, how much time is reasonable for each redo group? my site takes 4 0r 5 minutes and group cicle time as 20 minute.
We get advice to increase redo size. we just add more redo group to exten lopp time over 20 minute.
my redo log size as 2 G. we use oracle10g R4 in 32 bit window.
Thanks for any suggestion
Jim