Re: redo copy latch

From: <daud11_at_hotmail.com>
Date: Mon, 16 Nov 1998 00:55:05 GMT
Message-ID: <72nt59$8b5$1@nnrp1.dejanews.com>

Anjo

Please send the paper to me at my hotmail address. Thank you very much.

regards
Daud11

In article <364F7F25.3865AD91_at_us.oracle.com>, Kristiaan Johan Kolk <akolk_at_us.oracle.com> wrote:
>
> sleeps = 1445 (from v$latch) and total_waits =158916 (from v$system_event). So your
> redo copy latch is only (1445/158916)*100 percent of all the sleeps. This means less
> than 1 percent. So tuning this latch will not help that much, look for other latches
> that have a high sleep count as ones that can be tuned.
>
> Also enabling timed_statistics, will show you the wait time in v$system_event and that
> could help you determing how important 'latch free' is compared to the other wait
> events. (so the 1 percent could become even less).
>
> I wrote a paper about this method of tuning, let me know if you are interested....
>
> Anjo Kolk
>
> (akolk_at_us.oracle.com)
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Nov 15 1998 - 18:55:05 CST