Latch Question

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: Fri, 04 Feb 2000 23:28:46 GMT
Message-ID: <OgJm4.212$gH.3173@bgtnsc04-news.ops.worldnet.att.net>

Oracle says that the latch contention for the redo allocation or redo copy latch is calculated by misses/gets (or the immediate counterpart) from v$latch. But latch contention for LRU buffer cache latches is calculated by sleeps/gets.

Any ideas on why the redo latches wouldn't be calculated the same way. I thought for every request, there is only 1 miss, but possibly n sleeps.

Thanks for any help. Received on Fri Feb 04 2000 - 17:28:46 CST