Re: Redo Question

From: <mtek_at_mtekusa.com>
Date: Fri, 28 Mar 2008 08:29:56 -0700 (PDT)
Message-ID: <18f44e34-f8e9-4732-93c8-41488421cc99@a1g2000hsb.googlegroups.com>


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
Received on Fri Mar 28 2008 - 10:29:56 CDT

Original text of this message