Re: A Real Stinker to Solve - EXPERTS APPLY WITHIN (DB Crashing)

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 13 Oct 2006 07:05:14 -0700
Message-ID: <1160748314.747905.207080@m73g2000cwd.googlegroups.com>

Johne_uk wrote:
> > This is for db blocks. log_buffer is the parameter we need to know.
> > Since you didn't list it in the init.ora parameters, it must be
> > default, which is 512 KB or 128 KB * CPU_COUNT, whichever is greater.
> > See
> > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/memory.htm#38479
> > to see if you need to change it.
> >
>
> Hi, yes the log_buffer is curently at the default size of 512k. I'm
> reading the article you attached as regards resizing.
> Thanks

The 'redo buffer allocation retries' statistic is 4336. This should be nearly zero - thereore, I'm going to increase the size of log_buffer to 2M. Received on Fri Oct 13 2006 - 09:05:14 CDT