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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
