gnari wrote:
> is there a recommended procedure to estimate
> the best value for effective_cache_size on a
> dedicated DB server ?
Rule of thumb(On linux): on a typically loaded machine, observe cache memory of
the machine and allocate good chunk of it as effective cache.
To define good chunck of it, you need to consider how many other things are
running on that machine. If it is file server + web server + database server,
you have to allocate the resources depending upon requirement.
But remember It does not guarantee that it will be a good value. It is just a
starting point..:-) You have to tune it further if required.
HTH
Shridhar