| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem in redo buffer allocation retries
Hi, Mala,
Oracle manual says you need to either increase the log buffer size or speed up checkpointing (relevant parameters: LOG_BUFFER, LOG_CHECK_INTERVAL, LOG_CHECKPOINT_TIMEOUT). What's your log buffer size and your log buffer space wait (Note: it's not redo log space requests statistic)
Then the manual says if your log buffer is as high as 3 to 5 MB and still you get a high redo buffer allocation retries, try speeding up log writing; tune disk I/O, make sure redo is on another disk etc.
Let us know how you solve your problem.
Yong Huang
yong321_at_yahoo.com
you wrote:
After executing following query
select name,value from v$sysstat;
I found following data
redo buffer allocation retries 90
As Oracle recommended that this value shoul be near to zero.
I had look of redo latch contention but there is no redo latch contention.I
have checked all related parameter and found seem to be ok.
But my system is running fine.There is no problem with 100 users.
can any one suggest what can I look and solve this problem.
Thanks in advance.
Bye
mala
 |
 |