Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: redolog buffer
On 11 Apr 2005 23:03:54 -0700, nitin_kaul_at_rediffmail.com wrote:
>hi
>i work on 9.2.0.1.0 win 2k.
>
>I have 3 redolog groups each of 25mb.
>
>i have noticed that value of
>redo buffer allocation retries, redo log space wait time has been
>increasing.
>
>Also the number of archive files generated is increasing.
>
>so do i have to increase the size of redolog and what is the impact of
>redo buffer allocation retries, redo log space wait time on the
>database.
Besides what DA Morgan suggested, I'll look for 'cannot allocate new log' statements in alert.log, and increase # of redo log groups to 10 if they occur. I would also look for cause of increased archived log generation.
Lastly, I'd ditch running oracle on windows :)
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Wed Apr 13 2005 - 10:55:19 CDT