On Mar 28, 9:41 am, gazzag <gar...@jamms.org> wrote:
> On 28 Mar, 14:27, m...@mtekusa.com wrote:
>
>
>
> > Hi,
>
> > We are trying to see what the optimal size of our redo logs should be
> > and how many we should have.
>
> > We are running 10g, and we know that there is the MTTR_ parameter.
> > But for now, we want to the the log_checkpoint......
>
> > We have a high transaction system. Currently we have 5 redo logs,
> > each 50M. We are still receiving the error "Check point not
> > complete".
>
> > I'm not sure if creating more groups is the answer, shrinking the log
> > size, or making the logs bigger. We are researching it, but in the
> > meantime this error is happening frequently.
>
> > We are looking for some advice on what to do given the path we want to
> > take......
>
> > Thanks for any help.
>
> > John.
>
> http://groups.google.co.uk/group/com...server/browse_...
>
> HTH
>
> -g

We are really hurting here:

NAME VALUE
------------------------------- ----------------
redo buffer allocation retries 18,887
redo log space wait time 324,520