Re: Redo Question

On Mar 28, 9:41 am, gazzag <gar..._at_jamms.org> wrote:
> 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.
>
> http://groups.google.co.uk/group/comp.databases.oracle.server/browse_...
>
> HTH
>
> -g

Also, we forgot this parameter:

SQL> show parameters log_buffer

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
log_buffer                           integer     14286848