G
gus
Guest
in theory, a detailed analysis of your application and the data in the database could allow you to calculate optimum values for the -B and -L configuration parameters. in practice, it cannot be done because there are too many variables. you must find suitable values empirically. for -L, pick a number like 100,000 and then run your system a while. use promon program to look at the lock table high water mark. that is the maximum number of locks that were in use all at once. if you are near the amount of locks you allocated, then increase -L. allow some extra for expansion. As long as you don't run out, you have a suitable value. for -B, as long as you have adequate performance, you have enough. but do as Rob suggests. note also that if you do /not/ have adequate performance, it may be caused by something that has nothing to do with -B.
Continue reading...
Continue reading...