Re: redo copy latch

From: <xsun1913_at_my-dejanews.com>
Date: Wed, 11 Nov 1998 14:50:32 GMT
Message-ID: <72c87o$n35$1@nnrp1.dejanews.com>

In article <72blks$8jt$1_at_nnrp1.dejanews.com>, daud11_at_my-dejanews.com wrote:
> Hi
>
> The ratio of MISSES to GETS for redo copy latch is more than 90% for my
> oracle database. Does that mean that there is a problem with contention for
> the redo copy latch? Should I increase the parameter LOG_SIMULTANEOUS_COPIES
> to twice the number of CPU? Currently LOG_SIMULTANEOUS_COPIES = no of CPU
> (2).
>
> Some explanations from you guys out there will be appreciated.
>
> thanks
> Daud11
>

Hi,

There is contention for redo copy latch on your Oracle database. You could set the parameter: LOG_SIMULTANOUS_COPIES to 2 * # of CPUs. I had a situation in which the ratio is about 50%, but the number of MISSES and GETS for redo copy latch were very small over a long period of time. It really didn't cause performance hit.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 08:50:32 CST