Hi again,

I should also probably mention that we have 12GB of memory, and we
very seldomly swap.
Here's the current memory stats:

total used free shared buffers cached
Mem: 12389244 9039688 3349556 0 431840 5392836
-/+ buffers/cache: 3215012 9174232
Swap: 4194192 92 4194100

Regards,
Faisal

On Wed, 12 Jan 2005 13:07:23 +0800, Faisal Abdullah <apairudin@...> wrote:
> Hi Ann,
>
> Our DefaultDbCachePages is commented out. So i guess we're running a
> default of 75 pages on our classic server. Is there a way to calculate
> the optimized value for this?
>
> Regards,
> Faisal
>
> On Mon, 10 Jan 2005 11:54:22 -0500, Ann W. Harrison
> <aharrison@...> wrote:
>
> > That's a problem. You've got the maximum number of hash slots and
> > you've still got long chains. Just out of curiosity, how many page
> > buffers are you using? Each page buffer in use is a lockable object,
> > thus a lock block and a hash table entry.
>


--
There are many ways of going forward, but there is only one way of
standing still.