Re: tuning redo logs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 21 Jan 2000 21:10:34 -0000
Message-ID: <948489908.26311.0.nnrp-07.9e984b29@news.demon.co.uk>

Gets and misses on the redo copy latch
are pretty irrelevant on multi-CPU systems. Look at immediate_gets and immediate_misses. (you will probably find immediate_gets will be just a little larger than the GETS count on the redo allocation latch).

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Christ Follower wrote in message <86afu7$j0l$1_at_nnrp1.deja.com>...
>I inspected V$LATCH, and the GETS and MISSES are as follows.
>
>redo allocation 1051950 73
>redo copy 221 197
>redo writing 429761 20
>
>We are running Oracle and a SUN Solaris with 4 CPUs. I am trying to
>increase the hit ratio for redo copy. I followed Oracle manual and
>increased LOG_SIMULTANEOUS_COPIES from 4 to 8 but it did not help.
>(Actually it seemed worse.) What else can I try?
>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jan 21 2000 - 15:10:34 CST