cache buffer chain latch

From: Allan Plesniarski <aplesnia_at_my-deja.com>
Date: Fri, 14 Jan 2000 16:53:18 GMT
Message-ID: <85nk9m$47v$1@nnrp1.deja.com>

Hello

I am having a problem, every couple of minutes the cpu stops running at 99% and drops to under 50% utilization. This lasts for a minute before the system picks up again and continues merrily on it's way.

The wait that is blocking the processes is a "cache buffer chain" latch (different to cache buffer lru chain).

Unfortunately I have very little information on the cache buffer chain latch. The only thing I found was a vague reference to freelists but the process is not doing any large amount of inserting at that time. The processes are just doing queries at that time, no commits/inserts or deletes are going on.

If anyone knows of some references, it would be appreciated.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 14 2000 - 10:53:18 CST