latches: cache buffers chains

From: <chuckh_at_safeplace.net>
Date: Tue, 11 May 1999 16:30:21 GMT
Message-ID: <7h9luu$85s$1@nnrp1.deja.com>

I recently increased the buffer cache size to 300m on a 4 cpu NT Oracle database. Since then I've noticed a lot more misses on the "cache buffers chains" latch and a sleeps/miss ratio of 73.2%. What can I do to reduce the number of misses on the latch and reduce the number of sleeps? There seems to be no documentation on tuning this latch.

The hit ratio on it is .997. Should I even be concerned about it?

This database used to be heavily i/o bound. Now during peak times I see all 4 cpus pegged at 100% with very little disk activity. Is this latch the culprit for the high cpu usage, or is it just a result of having more buffers in memory to be scanned?

--
--

Chuck Hamilton
chuckh_at_safeplace.net

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Tue May 11 1999 - 11:30:21 CDT