Re: redo copy latch

From: Kristiaan J. Kolk <akolk_at_ix.netcom.com>
Date: 1997/03/17
Message-ID: <01bc32a9$9107ca80$5dac5ccf@akolk>#1/1

Tuning latches is very difficult and not really necessary. Tuning the application will give you a
much bigger performance boost. Also setting the LOG_SIMULTANEOUS_COPIES too high
will have a reverse effect.

--A.

Randy H. Julien <julienr_at_ncr.disa.mil> wrote in article <3329401D.13A8_at_ncr.disa.mil>...
> Fellow DBAs--
>
> I have been attempting to correct a very poor .003 hit ratio on my redo
> copy latch by first incrementing LOG_SIMULTANEOUS_COPIES to 8, and also
> by setting LOG_ENTRY_PREBUILD_THRESHOLD > 0. COPIES doesn't seem to
> help, and THRESHOLD doesn't seem to be supported under Oracle 7.3.2 on
> SUN/Solaris 2.4. In fact, THRESHOLD prevents instance start. Is there
> a replacement THRESHOLD setting/command, or another method for
> prebuilding redo?
>
> Any help is greatly appreciated
>
> Thanks
>
> Randy
>
Received on Mon Mar 17 1997 - 00:00:00 CST