On Thu, Jul 06, 2000 at 05:51:11PM -0500, Tab Trepagnier wrote:
> The critical change I made to our server was to raise the AIX VMTune "minperm"
> parameter from its default of just under 20% to 35%.
> That allowed the "processes" to lock in 179 MB of memory as "permanent" which 
> is
> equal to the DB buffer pool plus 83 MB.
> Disk paging (in and out) dropped from plateaus of 250 / sec to as few as 5 /
> minute.  Response is almost instantaneous.

For those running your server on solaris you can do pretty much the same
thing by setting forcedirectio if you use files on mounted filesystems.
Doing this I can give my db buffer a ton of memory without worry about it
being paged out.