Re: Redo Question
Date: Fri, 28 Mar 2008 07:41:45 -0700 (PDT)
Message-ID: <d90e73a8-cd97-41c2-82b5-3d928ac86569@e23g2000prf.googlegroups.com>
On 28 Mar, 14:27, m..._at_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.
HTH -g Received on Fri Mar 28 2008 - 09:41:45 CDT