C
ChUIMonster
Guest
There are exceptions to every rule. Our original poster wanted a formulaic approach to setting -bithold and has rejected reasonable attempts to explain why this isn't appropriate. If one needs a formula for -bithold I happen to think that my formula is excellent. Formula or not -- if you think that you need a large -bithold then your real problem is crappy code. If you cannot fix the crappy code and you cannot address the long running transactions you still need to be aware that large -bithold values are NOT normal or ok and should not be viewed as something to set and then wash ones hands of. Dmitri's example of being alerted well before actually reaching your company's -bithold is a good example of taking it seriously and treating the problem as the serious threat to system stability that it is. IMHO anyone who wants to set -bithold greater than 100MB really needs to explain WHY, in detail, and then go on to explain what else they are doing to resolve the threat to their data. (If that explanation does not include fixing the crappy code then it is incomplete and seriously flawed.)
Continue reading...
Continue reading...